hello everybody,
we are trying to move the data from table1 into table2 using a plpgsql stored
procedure which is performing simple a data conversion
there are about 50 million rows
the tables are relatively simple, less than a dozen columns, most are integer,
a couple are char(32) and one is
On 08.08.2012, at 22:04, Merlin Moncure wrote:
> What is the general structure of the procedure? In particular, how
> are you browsing and updating the rows?
Here it is -
BEGIN
for statistics_row in SELECT * FROM statistics ORDER BY time ASC
LOOP
...
... here some very minimal trans
I want to congratulate whoever came up with the idea for the version switch in
the documentation!
I am still furious about Google still "finding" and displaying on top the
documentation of 7.x long after 8.x was out… ;)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
hi guys,
yesterday we upgraded 8.x to 9.x
in one table we have nearly 50 million records which are, every night, crunched
by an insanely complex stored procedure written in plpgsql
this takes normally 3 to 3 1/2 hours
after the upgrade it took only 2 hours
do you think this is because 9.x per
> A response to this sort of question from the .org TLD redelegation is
> still available online:
> http://archive.icann.org/en/tlds/org/questions-to-applicants-13.htm#Response13TheInternetSocietyISOC.
> The details in that answer are all obsolete, of course, since it's
> from several years (and Po
I have been looking into heroku lately, they run on PostgreSQL -
https://postgres.heroku.com/postgres
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Since this PGCon 2011 page has no slides -
http://www.pgcon.org/2011/schedule/events/361.en.html
I Googled for "sharding" and "PostgreSQL" and I found this -
http://www.databasesoup.com/2012/04/sharding-postgres-with-instagram.html
"On Tuesday last week we had a terrific SFPUG meeting at which
