From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sanjaya Vithanagama
Sent: Sunday, November 23, 2014 10:52 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Avoiding deadlocks when performing bulk update and delete
operations
Hi All,
We
Is there a good way to individually list the DDL for all individual data
base objects?
Running a data base dump like:
pg_dump mydatabase mydatabase-database.sql
produces one big file with all the DDL and DML to restore the data base,
which is very convenient for most cases.
Using that I
Alexis ale...@bernard.io writes:
I have a GIN index but the planner rechecks the condition. When many rows
are foud in the index that is very slow:
You're assuming a fact not in evidence, namely that the recheck condition
is being used at runtime. The planner will *always* attach a recheck
Le 2014-11-24 à 10:14, Berend Tober bto...@broadstripe.net a écrit :
Is there a good way to individually list the DDL for all individual data base
objects?
snip
grep -v '^;' listfile | while read a b c n
do
a=${a/;}
echo $a f
pg_restore -L f -f outputdir/$a
Berend Tober wrote:
Is there a good way to individually list the DDL for all individual data
base objects?
These threads might interest you:
http://www.postgresql.org/message-id/AANLkTikLHA2x6U=q-t0j0ys78txhfmdtyxjfsrsrc...@mail.gmail.com
François Beausoleil wrote:
Le 2014-11-24 à 10:14, Berend Tober bto...@broadstripe.net a écrit :
Is there a good way to individually list the DDL for all individual data base
objects?
snip
Were you aware that pg_restore can restore to STDOUT, and output DDL for only a
single named
You should probably look at the pg_extractor utility.
https://github.com/omniti-labs/pg_extractor
With it, you can dump individual or selected objects to separate
directories.
On Mon, Nov 24, 2014 at 11:00 AM, Alvaro Herrera alvhe...@2ndquadrant.com
wrote:
Berend Tober wrote:
Is there a
On 11/24/2014 08:12 AM, Berend Tober wrote:
François Beausoleil wrote:
Le 2014-11-24 à 10:14, Berend Tober bto...@broadstripe.net a écrit :
Is there a good way to individually list the DDL for all individual
data base objects?
snip
Were you aware that pg_restore can restore to STDOUT,
Adrian Klaver wrote:
On 11/24/2014 08:12 AM, Berend Tober wrote:
François Beausoleil wrote:
Le 2014-11-24 à 10:14, Berend Tober bto...@broadstripe.net a écrit :
Is there a good way to individually list the DDL for all individual
data base objects?
snip
Were you aware that pg_restore
Melvin Davidson wrote:
You should probably look at the pg_extractor utility.
https://github.com/omniti-labs/pg_extractor
With it, you can dump individual or selected objects to separate
directories.
That looks like what I'm looking for. (Note: I did Google searching, but
apparently did not
On Mon, 24 Nov 2014 14:51:42 +1100
Sanjaya Vithanagama svithanag...@gmail.com wrote:
Hi All,
We have a single table which does not have any foreign key references.
id_A (bigint)
id_B (bigint)
val_1 (varchar)
val_2 (varchar)
The primary key of the table is a composite of id_A and
11 matches
Mail list logo
