Re: [BUGS] BUG #2208: Low performance on select

2006-01-25 Thread Michael Fuhr
On Wed, Jan 25, 2006 at 12:32:31PM +, Fahri CAKIROGLU wrote: > Consecutive selects from three different tables > causes low performance(about 1500 ms). > Same select count from two tables gives good performance(about 30 ms). This might be due to caching. When you query two tables all of the p

[BUGS] BUG #2207: PG Database Server 8.1 Service doesnt start

2006-01-25 Thread Pramod Kudva
The following bug has been logged online: Bug reference: 2207 Logged by: Pramod Kudva Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows XP Professional Description:PG Database Server 8.1 Service doesnt start Details: This seems to be

[BUGS] BUG #2208: Low performance on select

2006-01-25 Thread Fahri CAKIROGLU
The following bug has been logged online: Bug reference: 2208 Logged by: Fahri CAKIROGLU Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: windows nt 2000 Description:Low performance on select Details: Consecutive selects from three differen

Re: [BUGS] BUG #2204: Feature Req: Unique output column names

2006-01-25 Thread Brandon Black
On 1/24/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Tom Lane wrote: > > > I haven't looked at SQL99 or SQL2003, but most likely they say the same > > thing in two or three times as many words ;-) > > Thanks for the pointer. In SQL 2003, this is 7.12 > : > > 17) Case: > a) If the i-th in the

[BUGS] BUG #2209: Low performan on consecutive selects

2006-01-25 Thread Fahri CAKIROGLU
The following bug has been logged online: Bug reference: 2209 Logged by: Fahri CAKIROGLU Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows nt 2000 Description:Low performan on consecutive selects Details: Consecutive selects from thr