Re: [GENERAL] Should I create an index for partition with fixed key?

NSERT INTO req_google_com VALUES ('google_com', now()), ('google_com', now()); -- Sergey Samokhin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How do I store tables on a remote host?

oxy I've found: https://developer.skype.com/SkypeGarage/DbProjects/PlProxy http://pgfoundry.org/projects/plproxy/ -- Sergey Samokhin -- 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 do I store tables on a remote host?

le systems and tablepaces has just come to my mind, but I have a feel that there may be an analouge built into PG. Thanks. -- Sergey Samokhin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Should I create an index for partition with fixed key?

n? Will there be any benefits of having an index on site_id column? When I first read it, I decided that if all rows have the same key (say site_id = 'google_com') then there is no need in index. Thanks. -- Sergey Samokhin -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] A safe way to upgrade table definitions by using ALTER's

teve Atkins offered seem what I have been looking for so far. Thanks. -- Sergey Samokhin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] A safe way to upgrade table definitions by using ALTER's

ion uses (data types, constraints, modificators etc), stored procedures etc. Thanks. -- Sergey Samokhin P.S. If there is other convinient way to do upgrades which I've missed - please let me know. I'm still a novice in the PostgreSQL/SQL world. -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] It looks like transaction, but it isn't transaction

Hello, Tom. On Thu, Aug 27, 2009 at 5:25 AM, Tom Lane wrote: > Yes, if it's submitted as a single Query message, that's what happens. > Thanks for the detailed explanation. -- Sergey Samokhin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] It looks like transaction, but it isn't transaction

al" - I should write a bug report to the author of the driver. -- Sergey Samokhin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] It looks like transaction, but it isn't transaction

appear in the future. Is this behavior explained somewhere in documentation in more detail? How does this behaviour differ from the traditional transactions which are defined by enclosing SQL commands in BEGIN/COMMIT? Thanks. -- Sergey Samokhin -- Sent via pgsql-general mailin

Re: [GENERAL] How to simulate crashes of PostgreSQL?

nd(s). I haven't thought about it yet. It's possible the place where I should use timeouts on the operations involving calls to PostgreSQL. -- Sergey Samokhin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

Re: [GENERAL] What approach should I use instead of creating tables on the fly?

Hello, Craig. > Table partitioning and table inheritance. See the manual and the list > archives. Thanks for mentioning "partitioning" feature! It seems to be what I've been looking for so far. -- Sergey Samokhin -- Sent via pgsql-general mailing list (pgsql-general@po

Re: [GENERAL] How to simulate crashes of PostgreSQL?

who has answered in this topic! It was very helpful to read it! -- Sergey Samokhin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] What approach should I use instead of creating tables on the fly?

may be obvious solution I haven't ever hear about. Please point out it. Thanks. -- Sergey Samokhin -- 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 simulate crashes of PostgreSQL?

h from the client's point of view. Is using kill what everyone should use for these purposes? Thanks. -- Sergey Samokhin -- 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 should I deal with disconnects during insert?

been inserted or not. Which way do you prefer and why? Is there a way to do #1 (it's a bit cleaner and simpler to implement)? Thanks. -- Sergey Samokhin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general