Re: [HACKERS] Bug: Unreferenced temp tables disables vacuum to update xid

Joshua D. Drake wrote: Ping? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I spent the better part of this evening tracking down a problem with a high velocity database. The database had entered the point of no return by invoking xidStopLimit. This by itself isn't a problem because yo

Re: [HACKERS] Random plan selection in DBT-3

ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > There might be regularity in the plan selection. When I connect to postgres > newly, I see plans { A, B, A, A ... }. Then disconnect, re-connect and send > the same EXPLAINs, the same pattern was reproduced. Hmph ... maybe some effect associated with

Re: [HACKERS] Random plan selection in DBT-3

Tom Lane <[EMAIL PROTECTED]> wrote: > ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > > I tested 8.3beta4 with DBT-3 (TPC-H) and found unstable selection of plans. > > Planner randomly selected two types of plans (A, B) when I repeated EXPLAIN. > > Are you sure the statistics weren't changing und

Re: [HACKERS] Random plan selection in DBT-3

ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > I tested 8.3beta4 with DBT-3 (TPC-H) and found unstable selection of plans. > Planner randomly selected two types of plans (A, B) when I repeated EXPLAIN. Are you sure the statistics weren't changing underneath you (due to auto-vacuum or auto-analyze)

[HACKERS] Random plan selection in DBT-3

I tested 8.3beta4 with DBT-3 (TPC-H) and found unstable selection of plans. Planner randomly selected two types of plans (A, B) when I repeated EXPLAIN. One of the conditions is used in Seq Scan Filter in Plan A. In contrast, the same condition is used in Hash Join filter in Plan B. Plan A is fast

Re: [HACKERS] OUTER JOIN performance regression remains in 8.3beta4

"Kevin Grittner" <[EMAIL PROTECTED]> writes: > There was a serious performance regression in OUTER JOIN planning > going from 8.2.4 to 8.2.5. I know Tom came up with some patches to > mitigate the issues in 8.2.5, but my testing shows that problems > remain in 8.3beta4. Please try the attached p

Re: [HACKERS] [BUGS] BUG #3852: Could not create complex aggregate

"Sokolov Yura" <[EMAIL PROTECTED]> writes: > create or replace function add_group(grp anyarray, ad anyelement, size int4) > returns anyarray > language plpgsql > ... > create aggregate build_group(anyelement, int4) ( > SFUNC= add_group, > STYPE = anyarray > ); > ERROR: argument declared "any

Re: [HACKERS] pg 8.3 Windows installer suggestion

>Both options already exist in 8.3; pg_log can be set in postgresql.conf >'log_directory') and pg_xlog can be set at initdb time. > Yes, I know that, but I meant include the option directly in the msi installer (which already let the user initialyse the db cluster) would be a 'nice to have'. Thi

Re: [HACKERS] Dynamic Partitioning using Segment Visibility Maps

On Sunday 06 January 2008 05:48, Markus Schiltknecht wrote: > What I'm saying is, that SE doesn't partition the segments into > different table spaces. Thus I don't consider it "database partitioning" > in the first place. As I currently understand it, it's: > > table -- 1:1 -- table space -- 1:n -

Re: [HACKERS] beta4 accepts foreign key of different type than column

On Sun, Jan 06, 2008 at 04:07:40PM +, Gregory Stark wrote: > "Andrew Dunstan" <[EMAIL PROTECTED]> writes: > > > Louis-David Mitterrand wrote: > >> Hi, > >> > >> I changed the data type on a column (to an enum) but the previous foreign > >> key > >> to the old table (replaced by the enum) is

Re: [HACKERS] beta4 accepts foreign key of different type than column

"Andrew Dunstan" <[EMAIL PROTECTED]> writes: > Louis-David Mitterrand wrote: >> Hi, >> >> I changed the data type on a column (to an enum) but the previous foreign key >> to the old table (replaced by the enum) is still accepted event though the >> data types are now different. Is that the expect

[HACKERS] my bad (was: Re: beta4 accepts foreign key of different type than column

On Sun, Jan 06, 2008 at 10:18:35AM -0500, Andrew Dunstan wrote: > Louis-David Mitterrand wrote: >> Hi, >> >> I changed the data type on a column (to an enum) but the previous >> foreign key to the old table (replaced by the enum) is still accepted >> event though the data types are now differe

Re: [HACKERS] beta4 accepts foreign key of different type than column

Louis-David Mitterrand wrote: Hi, I changed the data type on a column (to an enum) but the previous foreign key to the old table (replaced by the enum) is still accepted event though the data types are now different. Is that the expected behavior? CREATE TABLE person_to_event ( id_per

[HACKERS] beta4 accepts foreign key of different type than column

Hi, I changed the data type on a column (to an enum) but the previous foreign key to the old table (replaced by the enum) is still accepted event though the data types are now different. Is that the expected behavior? CREATE TABLE person_to_event ( id_person integer NOT NULL, id_event

Re: [HACKERS] pg 8.3 Windows installer suggestion

jMartinez wrote: Would it be possible to add an option to the pg 8.3 Windows installer to separate the pg_log and pg_xlog folders from tha data one? Both options already exist in 8.3; pg_log can be set in postgresql.conf ('log_directory') and pg_xlog can be set at initdb time. -- Euler Ta

Re: [HACKERS] Tuning Postgresql on Windows XP Pro 32 bit

On Jan 3, 2008 8:57 PM, Doug Knight <[EMAIL PROTECTED]> wrote: > All, > Is there a place where I can find information about tuning postgresql > running on a Windows XP Pro 32 bit system? I installed using the binary > installer. I am seeing a high page fault delta and total page faults for one >

Re: [HACKERS] Dynamic Partitioning using Segment Visibility Maps

On Jan 6, 2008 4:09 PM, Markus Schiltknecht <[EMAIL PROTECTED]> wrote: > Hi, > > Gokulakannan Somasundaram wrote: > > > > > > On Jan 5, 2008 6:15 PM, <[EMAIL PROTECTED] > > wrote: > > > > > > One thought I had back then, with partitioned tables was "gee -- > B-tree >

Re: [HACKERS] Dynamic Partitioning using Segment Visibility Maps

Hi, Robert Treat wrote: On Saturday 05 January 2008 14:02, Markus Schiltknecht wrote: To satisfy all the different requirements of partitioning with segments based partitioning, we'd have to allow a table to span multiple table spaces. I'm not very keen on going that way. Why? Uh.. if a table

Re: [HACKERS] Dynamic Partitioning using Segment Visibility Maps

Hi, Gokulakannan Somasundaram wrote: On Jan 5, 2008 6:15 PM, <[EMAIL PROTECTED] > wrote: One thought I had back then, with partitioned tables was "gee -- B-tree index is already doing a partition; why do a manual partition on top of that?". Can you plea

Re: [HACKERS] Bug: Unreferenced temp tables disables vacuum to update xid

Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I spent the better part of this evening tracking down a problem with a high velocity database. The database had entered the point of no return by invoking xidStopLimit. 8.2.4 Joshua D. Drake

[HACKERS] Bug: Unreferenced temp tables disables vacuum to update xid

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I spent the better part of this evening tracking down a problem with a high velocity database. The database had entered the point of no return by invoking xidStopLimit. This by itself isn't a problem because you just vacuum right? Well we vacu

Re: [HACKERS] Dynamic Partitioning using Segment Visibility Maps

On Jan 6, 2008 11:27 AM, <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Sun, Jan 06, 2008 at 01:12:32AM +0530, Gokulakannan Somasundaram wrote: > > On Jan 5, 2008 6:15 PM, <[EMAIL PROTECTED]> wrote: > > > > > > > > One thought I had back then, with partitioned

Re: [HACKERS] Dynamic Partitioning using Segment Visibility Maps

On Jan 6, 2008 3:00 AM, Robert Treat <[EMAIL PROTECTED]> wrote: > On Saturday 05 January 2008 14:02, Markus Schiltknecht wrote: > > >> To satisfy all the different requirements of partitioning with > segments > > >> based partitioning, we'd have to allow a table to span multiple table > > >> space

Re: [HACKERS] [PATCH] pg_hba.conf.sample: mention www.postgresql.org

Jari Aalto <[EMAIL PROTECTED]> writes: > * Sat 2008-01-05 Peter Eisentraut <[EMAIL PROTECTED]> >> Furthermore I think it is fairly obvious that you can find >> documentation on the website. > A direct URL will help ´people to head for right direction. Somebody who has found postgresql.conf in the

Re: [HACKERS] [PATCH] pg_hba.conf.sample: mention www.postgresql.org

* Sat 2008-01-05 Peter Eisentraut <[EMAIL PROTECTED]> * Message-Id: [EMAIL PROTECTED] > Jari Aalto wrote: > >> Here is usggestion to add URL to documentation. > > But there are other sources for the documentation. It might be > preferrable to use a local copy. The local copy is not necessarily ins