headers
cluster | 1 Jul 2007 01:23
Picon

Bitmap index?

In postgresql 8.2 I need a bitmap index for a certain column, but how do 
I create it?
(No, a btree is not sufficient. :-)  )

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Permalink | Reply | 1 comment |
headers
Michael Glaesemann | 1 Jul 2007 02:31
Gravatar

Re: Bitmap index?


On Jun 30, 2007, at 18:23 , cluster wrote:

> In postgresql 8.2 I need a bitmap index for a certain column, but  
> how do I create it?
> (No, a btree is not sufficient. :-)  )

Where do you see that PostgreSQL has bitmap indexes?

http://www.postgresql.org/docs/8.2/interactive/indexes-types.html

PostgreSQL can combine multiple indexes and use a bitmap scan during  
query execution, but this is not an on-disk bitmap index.

http://www.postgresql.org/docs/8.2/interactive/indexes-bitmap-scans.html

Perhaps if you give more information concerning your situation and  
why you believe B-tree indexes are not sufficient, others on the list  
might be able to provide suggestions.

Michael Glaesemann
grzm seespotcode net

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/
Permalink | Reply | 0 comments |
headers
Martijn van Oosterhout | 1 Jul 2007 12:55
Favicon

Re: Looking for help regarding getting the latest inserted sequence value.

On Sat, Jun 30, 2007 at 11:21:59AM -0700, Richard Broersma Jr wrote:
> I don't want to derail the thread too much, but would it be nice if the returning could be used in
> a insert sub-query?

Absolutly, however the semantics are not so simple. I remember
something about when to invoke triggers? And what view should they get?
Does the trigger on the outer table get to see the effect of the nested
insert, for example.

I'm sure it will get done eventually, once the details have been sorted
out.

Have a nice day,
--

-- 
Martijn van Oosterhout   <kleptog <at> svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
Permalink | Reply | 0 comments |
headers
Magnus Hagander | 1 Jul 2007 14:00

Re: postgressqlnot support inwindows 2000

Dave Page wrote:
> 
>> siva prakash wrote:
>>> if i run the setup choose language then go to next button it shows error
>>> *"Failed to create process: 2!*
>> Please don't remove the mailinglist from the CC list, so others can
>> learn from the answers.
>>
>> The error you get indicates that your windows installation is broken. At
>> that point it tries to execute "msiexec" which is a part of windows
>> installer and a core piece of windows that's not working. You need to
>> make sure that it works properly before you can install PostgreSQL.
> 
> Unless I'm misreading it errors when the Next Button is clicked on the language dialog, which means
msiexec has already run once.

Yes, but it was not necessarily launched as "msiexec". If the file was
just double-clicked on, the path to msiexec will be fetched from the
registry and not the system PATH. That's the only explanation I can find.

> Siva; did you extract both msi files from the zip file before running the installer?

That gives a different error message - it starts msiexec and then
msiexec is the one that complains. This error indicates that it can't
even find msiexec.exe to run.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
(Continue reading)

Permalink | Reply | 1 comment |
headers
Marcus Engene | 1 Jul 2007 15:21
Picon

Re: stem & tsearch2, want different stemmed words

Oleg Bartunov wrote:
> On Sat, 30 Jun 2007, Marcus Engene wrote:
>
>> Hi!
>>
>> bond=> SELECT to_tsvector('default','animation animal');
>> to_tsvector
>> -------------
>> 'anim':1,2
>> (1 row)
>>
>> bond=>
>>
>> Sorry for a silly question, I wonder, how do I override this? I would 
>> want different stemmed words for these.
>
> create synonym dictionary. Read about this 
> http://www.sai.msu.su/~megera/wiki/Tsearch_V2_Notes
Many thanks!

For future googlers: do check what was in your pg_ts_cfgmap before updating;

update  pg_ts_cfgmap set dict_name='{ts_p5_syn,en_stem}' where
ts_name='default' and  tok_alias in
('lword', 'lpart_hword','lhword' );

;-P

Best regards,
Marcus
(Continue reading)

Permalink | Reply | 0 comments |
headers
Ben | 1 Jul 2007 17:27

Re: [ASK] create data ware house in postgre

On Jun 29, 2007, at 11:07 PM, adolf pandapotan wrote:

> Hello, please i'm to introduce my self,
>     I'm adolf, student, i'm new in postgre.I'm want to create a  
> data warehouse in postgre 8.4.2. Can anyone help me? Because i have  
> been try to search in google, but i can't find the details.

1. A "data warehouse" is a nebulous term. Can you be more specific?
2. It's Postgres or PostgreSQL. :)

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Permalink | Reply | 0 comments |
headers
Robert Treat | 1 Jul 2007 19:10
Picon

Re: greatest/least semantics different between oracle and postgres

On Saturday 30 June 2007 14:13, paul rivers wrote:
> > -----Original Message-----
> > From: pgsql-general-owner <at> postgresql.org [mailto:pgsql-general-
> > owner <at> postgresql.org] On Behalf Of Pavel Stehule
> > Sent: Saturday, June 30, 2007 10:37 AM
> > To: Bruno Wolff III; Pavel Stehule; pgsql-general <at> postgresql.org
> > Subject: Re: [GENERAL] greatest/least semantics different between oracle
> > and postgres
> >
> > > Maybe that reference was for an earlier version of Oracle and the
> >
> > definition
> >
> > > changed at some point? I only have access to version 9 and greatest and
> > > lest are strict there.
> >
> > I am installing OracleXE and I'll test it.
> >
> > Pavel
>
> At risk of putting my foot in my mouth again, greatest() returns null if
> one or more expressions are null for Oracle enterprise 9.2.0.7 and
> 10.2.0.3.
>
<snip examples>

Confirmed on Oracle 8.1.7.4.0 as well, so if it changed it was a ways back.   

--

-- 
Robert Treat
(Continue reading)

Permalink | Reply | 0 comments |
headers
Robert Treat | 1 Jul 2007 19:19
Picon

Re: Standby servers and incrementally updated backups

On Friday 29 June 2007 13:47, Erik Jones wrote:
> On Jun 29, 2007, at 10:15 AM, Jim Nasby wrote:
> > On Jun 25, 2007, at 4:54 PM, Erik Jones wrote:
> >> On Jun 25, 2007, at 4:40 PM, Simon Riggs wrote:
> >>> On Mon, 2007-06-25 at 16:00 -0500, Erik Jones wrote:
> >>>> On Jun 25, 2007, at 3:40 PM, Simon Riggs wrote:
> >>>>>>  If I'm correct, then for large databases wherein it can
> >>>>>> take hours to take a base backup, is there anything to be
> >>>>>> gained by
> >>>>>> using incrementally updated backups?
> >>>>>
> >>>>> If you are certain there are parts of the database not touched
> >>>>> at all
> >>>>> between backups. The only real way to be sure is to take file
> >>>>> level
> >>>>> checksums, or you can trust file dates. Many backup solutions
> >>>>> can do
> >>>>> this for you.
> >>>>
> >>>> Wait, um, what?  I'm still not clear on why you would want to run a
> >>>> backup of an already caught up standby server.
> >>>
> >>> Sorry, misread your question.
> >>>
> >>> While you are running a warm standby config, you will still want
> >>> to take
> >>> regular backups for recoverability and DR. These are additional
> >>> backups,
> >>> i.e they are not required to maintain the warm standby.
> >>>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Alexander Todorov | 1 Jul 2007 19:36
Picon
Gravatar

[pgsql-general] In memory tables/databases

Hello,
is there anything to emulate the MySQL memory table engine?
A straight forward solution is to create a ramfs volume and mount/link
content under /var/lib/postresql there. Then add some scripts to
save/restore databases when the server restarts.
I am wondering is there something else?

Greetings,
Alexander

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/
Permalink | Reply | 17 comments |
headers
Tom Lane | 1 Jul 2007 20:13
Picon

Re: [pgsql-general] In memory tables/databases

"Alexander Todorov" <alexx.todorov <at> gmail.com> writes:
> is there anything to emulate the MySQL memory table engine?
> A straight forward solution is to create a ramfs volume and mount/link
> content under /var/lib/postresql there. Then add some scripts to
> save/restore databases when the server restarts.
> I am wondering is there something else?

As long as shared_buffers is high enough, there doesn't seem to be much
point in worrying about this; the incremental performance gain will be
minimal since everything will be in RAM anyway.  Or do you think losing
the content of the database at server crash is a feature?

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
Permalink | Reply | 16 comments |

Gmane