On Wed, 27 Sep 2017 11:31:54 +0200
Tomas Vondra wrote:
> On 09/27/2017 10:08 AM, Jonathan Moules wrote:
> > Hi,
> > (Postgres 9.5 and 9.6)
> > We have a table of about 650million rows. It's a partitioned table, with
> > two "child" tables. We want to change its primary key type from int to
> > bi
On Sat, 16 Sep 2017 12:15:46 +0200
Rafal Pietrak wrote:
> W dniu 16.09.2017 o 09:33, Jehan-Guillaume de Rorthais pisze:
> >
> [-]
> >
> > I wrote something about this some years ago, this might do the trick for
> > you, maybe with some adjustments depending on your schema. The mai
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Le 01/11/2010 20:54, hubert depesz lubaczewski a écrit :
> On Mon, Nov 01, 2010 at 08:31:10PM +0100, Cédric Villemain wrote:
>> It should stick at a maximum of 3 * checkpoint_segments + 1, if it
>> exceed it will remove the extra files after.
>
> if y
reated to increase speed...
> Does there exist a similar tool for PostgreSQL?
There some work about this kind of feature but nothing officially
released AFAIK.
See http://www.pgcon.org/2010/schedule/events/233.en.html
>
>
> Regards,
>
> BTJ
>
- --
Jehan-Guillaume (iogu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/06/2010 16:00, Tom Lane wrote:
> "Jehan-Guillaume (ioguix) de Rorthais" writes:
>> Shouldn't locks only be on tables/indexes that are actually used by the
>> planner ?
>
> Well, yeah, they are. The planne
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have some trouble understanding the locking policy with partitioned
tables. Here is a simple schema based on a real one:
CREATE DATABASE test;
\c test
CREATE TABLE test(
id integer PRIMARY KEY,
id_dummy integer,
id_part1 integer
d some quick investigation on it, it seems it doesn't work with
extended queries neither.
> Regards, -- Shoaib Mir http://shoaibmir.wordpress.com/
- --
Jehan-Guillaume (ioguix) de Rorthais
www.dalibo.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.
approach are :
- cannot extract from SSL connections
- ISTM tshark only support PostgreSQL V3 protocol. So only work on
> 7.2 IIRC
> Yours, Laurenz Albe
- --
Jehan-Guillaume (ioguix) de Rorthais
www.dalibo.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Co
un as..." command or to
create the PostgreSQL service, is it still hapening with the 8.4 installer ?
Thanks for your help !
--
Jehan-Guillaume (ioguix) de Rorthais
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
