[HACKERS] Group by count() and indexes

2003-02-18 Thread Anuradha Ratnaweera
should be evaluated, so sort() will take most of the time. Is there a way to improve performance of this query? If not, please give some indication to do a workaround on the source itself, so perhaps I may be able to work out a patch. Thanks in advance. Anuradha -- Debian GNU/Linux

[HACKERS] Group by, count, order by and limit

2003-02-17 Thread Anuradha Ratnaweera
should be evaluated, so sort() will take most of the time. Is there a way to improve performance of this query? If not, please give some indication to do a workaround on the source itself, so perhaps I may be able to come out with a patch. Thanks in advance. Anuradha -- Debian GNU/Linux

Re: [HACKERS] Postgresql and multithreading

2002-10-19 Thread Anuradha Ratnaweera
this? otherwise I can try it', type posting was not differentiated from numerous `why don't YOU implement this feature' type postings ;) Anuradha -- Debian GNU/Linux (kernel 2.4.18-xfs-1.1) Life is too important to take seriously. -- Corky Siegel

Re: [HACKERS] Postgresql and multithreading

2002-10-17 Thread Anuradha Ratnaweera
unnecessary traffic on the list. Anuradha -- Debian GNU/Linux (kernel 2.4.18-xfs-1.1) I have found little that is good about human beings. In my experience most of them are trash. -- Sigmund Freud ---(end of broadcast

Re: [HACKERS] Postgresql and multithreading

2002-10-15 Thread Anuradha Ratnaweera
On Wed, Oct 16, 2002 at 12:59:57AM -0400, Bruce Momjian wrote: Anuradha Ratnaweera wrote: Is there any plans to make postgresql multithreading? We don't think it is needed, except perhaps for Win32 and Solaris, which have slow process creation times. Thanks, Bruce. But what I want

Re: [HACKERS] Postgresql and multithreading

2002-10-15 Thread Anuradha Ratnaweera
On Wed, Oct 16, 2002 at 01:25:23AM -0400, Bruce Momjian wrote: Anuradha Ratnaweera wrote: ... what I want to know is whether multithreading is likely to get into in postgresql, say somewhere in 8.x, or even in 9.x? It may be optional some day, most likely for Win32 at first, but we see

Re: [HACKERS] Peer to peer replication of Postgresql databases

2002-10-13 Thread Anuradha Ratnaweera
Mosix in any way. We have tested many programs from our parallel processing project with extreme success on our mosix cluster. Anuradha -- Debian GNU/Linux (kernel 2.4.18-xfs-1.1) Ginger snap. ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [HACKERS] Peer to peer replication of Postgresql databases

2002-10-13 Thread Anuradha Ratnaweera
... ;) Anuradha -- Debian GNU/Linux (kernel 2.4.18-xfs-1.1) All other things being equal, a bald man cannot be elected President of the United States. -- Vic Gold ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

Re: [HACKERS] Peer to peer replication of Postgresql databases

2002-10-13 Thread Anuradha Ratnaweera
On Fri, Oct 11, 2002 at 12:07:00PM -0400, Neil Conway wrote: [ pgsql-patches removed from Cc: list ] Anuradha Ratnaweera [EMAIL PROTECTED] writes: I am trying to add some replication features to postgres (yes, I have already looked at ongoing work), in a peer to peer manner. Did you

Re: [HACKERS] Peer to peer replication of Postgresql databases

2002-10-11 Thread Anuradha Ratnaweera
On Fri, Oct 11, 2002 at 04:04:29PM +0530, Shridhar Daithankar wrote: On 11 Oct 2002 at 16:29, Anuradha Ratnaweera wrote: On Fri, Oct 11, 2002 at 03:54:15PM +0530, Shridhar Daithankar wrote: I will look at it, too. Thanks for the link. In some cases, starting anew is faster than learning

Re: [HACKERS] Peer to peer replication of Postgresql databases

2002-10-11 Thread Anuradha Ratnaweera
requests to a mosix cluster anyway. Have already tested postgres on a mosix cluster, and as expected results are not good. (although mosix does the correct thing in keeping all the database backend processes on one node). Anuradha -- Debian GNU/Linux (kernel 2.4.18-xfs-1.1) Remember

[HACKERS] Peer to peer replication of Postgresql databases

2002-10-11 Thread Anuradha Ratnaweera
. Anuradha -- Debian GNU/Linux (kernel 2.4.18-xfs-1.1) The best audience is intelligent, well-educated and a little drunk. -- Maurice Baring ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] pg_ident.conf

2000-12-03 Thread anuradha
I have Red Hat Linux 6.2 , PostgreSQL 7.0.2. Could anybody help me to configure ident daemon using the file pg_ident.conf Thanks in advance, anuradha