Re: [HACKERS] statistics about tamp tables ...

2003-11-29 Thread Hans-Jürgen Schönig
Alvaro Herrera wrote: On Wed, Nov 26, 2003 at 05:34:28PM +0100, Hans-Jürgen Schönig wrote: The reason why I came up with this posting is slightly different: Assume a JDBC application which works with PostgreSQL + some other database. If you want to use both databases without PostgreSQL being un

Re: [HACKERS] statistics about tamp tables ...

2003-11-28 Thread Alvaro Herrera
On Wed, Nov 26, 2003 at 05:34:28PM +0100, Hans-Jürgen Schönig wrote: > The reason why I came up with this posting is slightly different: Assume > a JDBC application which works with PostgreSQL + some other database. If > you want to use both databases without PostgreSQL being unnecessarily > sl

Re: [HACKERS] statistics about tamp tables ...

2003-11-28 Thread Hans-Jürgen Schönig
Tom Lane wrote: =?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes: Recently I have come across a simple issue which made me think about it. When we create a tmp table (SELECT INTO, CREATE TABLE AS) the planner won't know anything about its content after creating it. Run ANALYZ

Re: [HACKERS] statistics about tamp tables ...

2003-11-26 Thread Tom Lane
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes: > Recently I have come across a simple issue which made me think about it. > When we create a tmp table (SELECT INTO, CREATE TABLE AS) the planner > won't know anything about its content after creating it. Run ANALYZE on the tem

[HACKERS] statistics about tamp tables ...

2003-11-26 Thread Hans-Jürgen Schönig
Recently I have come across a simple issue which made me think about it. When we create a tmp table (SELECT INTO, CREATE TABLE AS) the planner won't know anything about its content after creating it. Many people use temp tables heavy when the amount of data for a certain analysis has to be reduce