[HACKERS] Group by count() and indexes

2003-02-18 Thread Anuradha Ratnaweera
`id's 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

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

2003-02-17 Thread Anuradha Ratnaweera
x27;s 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/

Re: [HACKERS] Postgresql and multithreading

2002-10-18 Thread Anuradha Ratnaweera
But before doing that, naturally, I wanted to figure out if any of the core developers themselves have any plans of doing it. Now, I am trying hard to figure out why this `are you going to do this? otherwise I can try it', type posting was not differentiated from numerous `why don't

Re: [HACKERS] Postgresql and multithreading

2002-10-16 Thread Anuradha Ratnaweera
o would hopefully reduce 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 ---

Re: [HACKERS] Postgresql and multithreading

2002-10-15 Thread Anuradha Ratnaweera
se threads in the backend?) long, long ago. > If we discuss it, it ends up causing a lot of effort on our part for > the requestor to finally say, "Oh, gee, I didn't realize that." Please don't. See the "NB" at end of my first mail of this thread. An

Re: [HACKERS] Postgresql and multithreading

2002-10-15 Thread Anuradha Ratnaweera
On Wed, Oct 16, 2002 at 03:40:47PM +1000, Gavin Sherry wrote: > On Wed, 16 Oct 2002, Anuradha Ratnaweera wrote: > > > And a minor question is wheter it is legal to keep the _changes_ in such > > a project GPL? > > Do you mean 'relicence the forked copy'?

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

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

[HACKERS] Postgresql and multithreading

2002-10-15 Thread Anuradha Ratnaweera
Is there any plans to make postgresql multithreading? Thanks in advance (and also for all who commented to my question regarding replication.) Anuradha NB: please don't open fire to declare war on whether multithreading is needed for PGSql or not. I am just expecting a blac

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

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

2002-10-13 Thread Anuradha Ratnaweera
she meant.. ^^^ Correction: "that's what _HE_ meant..." ;) 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 -

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

2002-10-13 Thread Anuradha Ratnaweera
that I am not underestimating 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)---

[HACKERS] Peer to peer replication of Postgresql databases

2002-10-11 Thread Anuradha Ratnaweera
re welcome. 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]

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

2002-10-11 Thread Anuradha Ratnaweera
On Fri, Oct 11, 2002 at 03:54:15PM +0530, Shridhar Daithankar wrote: > > On 11 Oct 2002 at 16:16, Anuradha Ratnaweera wrote: > > > I am trying to add some replication features to postgres (yes, I have > > already looked at ongoing work), in a peer to peer manner. The

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

2002-10-11 Thread Anuradha Ratnaweera
ll not do sending 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.1

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 >

[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