[GENERAL] dump order by

Hi all, I would like to know if it is possible to dump a table ordered by its primary key. Take a look at the this test table... \d test Table "public.test" Column| Type | Modifiers ---+-+--- id

[GENERAL] migrate from PostgreSQL to Oracle

Hi all, I'm working with same db schema in PostgreSQL and Oracle, We mainly work in PostgreSQL but sometimes we need to copy schema and data from pg to oracle because some our customers want to use oracle instead of pg. Thus I'm looking for some linux script to migrate from pg to oracle. At th

Re: [GENERAL] Postgres 8.3 vs. 8.4 - Query plans and performance

). 8.3 query plan: http://explain.depesz.com/s/KdF (no problem) 8.4 query plan: http://explain.depesz.com/s/dO7 (problem query) Jo On 15.03.2011 17:24, Merlin Moncure wrote: On Mon, Mar 14, 2011 at 9:48 AM, Jo wrote: I set the work_mem to 100MB and the shared buffers are 2 GB The query plans

Re: [GENERAL] Postgres 8.3 vs. 8.4 - Query plans and performance

Hello, that's the 8.4 query plan: http://explain.depesz.com/s/dO7 The locale of the two databases is the same: SHOW LC_COLLATE command gives the locale: "de_DE.UTF-8". Regards, Jo On 14.03.2011 16:04, t...@fuzzy.cz wrote: Hello 2011/3/14 Jo: I set the work_mem t

Re: [GENERAL] Postgres 8.3 vs. 8.4 - Query plans and performance

.29281.33 rows=74 width=8)" "Index Cond: (relation_id = $0)" "Filter: ((member_role = 'outer'::text) AND (member_type = 'W'::bpchar) AND (subplan))" "SubPlan" " -> Index Sc

[GENERAL] Postgres 8.3 vs. 8.4 - Query plans and performance

nning VACUUM). Are there some major changes from 8.3 to 8.4 that cause this bad performance? Regards, Jo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] how to configure postgresql to display messages in italian

Modificatori +-+ matricola | character varying(17) | not null iscrizione | date| not null nome_cane | character varying(12) | thank you, jo ---

[GENERAL] date ranges

Hello, I would like to know if there's a simple way to customize the range for dates, to avoid people insert dates before 1900 and after 2020, for example. Thank you for your time, jo ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [GENERAL] invalid page header

Just a little followup on this problem. We've moved the database to another server where it ran without problems. HP just released new raid controller drivers for Suse and a firmware update for the controller itself. Until now the problem hasn't occurred anymore. Thanks! Jo. Chr

Re: [GENERAL] invalid page header

ection: Flags: 0x0001 (LEAF) Blocks: Previous (12811) Next (12769) Level (0) 1ff0: 0b32 e131 0100 .2...1.. *** End of Requested Range Encountered. Last Block Read: 39248 *** Tom Lane wrote: Jo De Haes <[EMAIL PROTECTED]> writes: I asked the developpe

Re: [GENERAL] invalid page header

ntion that same block returns the correct data and the complete database is fine. Where is the problem? The fact that i'm running 2 different instances? Cache on raid controller messing up? Some strange voodoo? Jo De Haes wrote: Ok, So we reran everything and go

Re: [GENERAL] invalid page header

Tom Lane wrote: "Qingqing Zhou" <[EMAIL PROTECTED]> writes: "Jo De Haes" <[EMAIL PROTECTED]> wrote CETERROR: XX001: invalid page header in block 22182 of relation "dunn_main" I suppose there is no system error happens during the period (like

[GENERAL] invalid page header

27;t have a heavy insert/update load. Does anybody have any clues or can tell me how to more exactly pinpoint the problem? Hardware/bug in Postgresql? Any advice would be more than welcome, because I'm afraid the developper will demand to have an Oracle installation if I can