On lör, 2010-05-15 at 22:50 -0700, Yang Zhang wrote:
> On Sat, May 15, 2010 at 10:20 PM, Peter Eisentraut wrote:
> > You have null bytes in the data value, which is not supported very well
> > in PL/Python. Try the 9.0 beta version; it should be fixed there.
>
> Thanks. Out of curiosity, is this
On Thursday 13 May 2010 17.50:31 Wang, Mary Y wrote:
> http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-A
> LL (I only found the documentation for 8.3.10), and it looks like
> pg_dumpall > outfile is the best choice.
pg_dumpall or by-database pg_dump ha the advantage that it
Dear postgresql experts,
I want to know if postgresql has facilities for getting the first and or the
last in a by group.
Suppose I have the following table:
resnr,dep,arr,cls,dbd meaning reservationsnumber, departure station, arrival
station, the class of the reservation and the daysbeforedep
Dino Vliet wrote on 16.05.2010 18:07:
Dear postgresql experts,
I want to know if postgresql has facilities for getting the first and or
the last in a by group.
Suppose I have the following table:
resnr,dep,arr,cls,dbd meaning reservationsnumber, departure station,
arrival station, the class of
On 16/05/2010 16:59, Adrian von Bidder wrote:
> * pint in time recovery
This is what happens *after* work - this side of the pond, anyway :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Joao Ferreira gmail wrote:
We have hundreds or thousands of unreachable and unmaintained PG
instalations. I'm totally unable to experiment in each of them. Usage
profile can range from 100 rows per hour to 1000, 10.000, 50.000...
sustained... for several days... or even forever... CPU's and IO
su
On Sun, May 16, 2010 at 12:32 PM, Greg Smith wrote:
> Just make sure you're producing good backups of these systems then. You can
> expect to run into one of the data eating bugs in 8.1 eventually. You'll
> probably have a corrupt database from the sort of fsync issues cheap storage
> introduce
On Fri, May 14, 2010 at 5:59 PM, Joao Ferreira gmail
wrote:
>
> For several reasons I can _not_ upgrade pg. I must use 8.1.4 and just
> live with it. And learn to work around the issues it might bring me.
> Additionally I can not change the cheap storage we ship in some lower
> end versions of our
On Sun, May 16, 2010 at 1:19 PM, Jaime Casanova wrote:
> On Fri, May 14, 2010 at 5:59 PM, Joao Ferreira gmail
> wrote:
>>
>> For several reasons I can _not_ upgrade pg. I must use 8.1.4 and just
>> live with it. And learn to work around the issues it might bring me.
>> Additionally I can not chan
On Thu, May 13, 2010 at 7:05 PM, Joao Ferreira
wrote:
>
> Hello all,
>
> I have a hard situation in hands. my autovacuum does not seem to be able
> to get his job done;
>
> database is under active INSERTs/UPDATEs;
> CPU is in aprox 50% iowait for the past 5 hours;
>
vmstat divides io percent (la
Dino Vliet wrote:
> I want to know if postgresql has facilities for getting the first and or the
> last in a by group.
> Suppose I have the following table:
> resnr,dep,arr,cls,dbd meaning reservationsnumber, departure station, arrival
> station, the class of the reservation and the daysbefor
Recently, I try to introduce my friend to use PostgreSQL.
However, he first impression is that. PostgreSQL is much slower compared to
MySQL. He realize he has to wait for 7 seconds, to create a tmp database.
He run a command through pgadmin GUI.
"CREATE DATABASE TMP;"
I try to run through comm
Yan Cheng CHEOK writes:
> Recently, I try to introduce my friend to use PostgreSQL.
> However, he first impression is that. PostgreSQL is much slower compared to
> MySQL. He realize he has to wait for 7 seconds, to create a tmp database.
Just for the record, CREATE DATABASE in postgres has appro
The documentation at
http://www.postgresql.org/docs/8.3/static/datatype-datetime.html seems to
say that the special value 'infinity' ("later than all other time stamps")
should work for an date-time column, and the type "date" is listed as among
the date-time data types.
But I can't get 'infini
On Mon, May 17, 2010 at 1:17 PM, Ken Winter wrote:
> The documentation at
> http://www.postgresql.org/docs/8.3/static/datatype-datetime.html seems to
> say that the special value ‘infinity’ (“later than all other time stamps”)
> should work for an date-time column, and the type “date” is listed
"Ken Winter" writes:
> The documentation at
> http://www.postgresql.org/docs/8.3/static/datatype-datetime.html seems to
> say that the special value 'infinity' ("later than all other time stamps")
> should work for an date-time column, and the type "date" is listed as among
> the date-time data ty
Le 17/05/2010 03:21, Yan Cheng CHEOK a écrit :
> Recently, I try to introduce my friend to use PostgreSQL.
>
> However, he first impression is that. PostgreSQL is much slower compared to
> MySQL. He realize he has to wait for 7 seconds, to create a tmp database.
>
> He run a command through pgad
The pgadmin result seems different with my machine. My friend and I are using
Windows machine. Are you using Linux machine?
Thanks and Regards
Yan Cheng CHEOK
--- On Mon, 5/17/10, Guillaume Lelarge wrote:
> From: Guillaume Lelarge
> Subject: Re: [GENERAL] Why Performance of SQL Query is *muc
On Sun, May 16, 2010 at 7:21 PM, Yan Cheng CHEOK wrote:
> Recently, I try to introduce my friend to use PostgreSQL.
>
> However, he first impression is that. PostgreSQL is much slower compared to
> MySQL. He realize he has to wait for 7 seconds, to create a tmp database.
>
> He run a command thro
19 matches
Mail list logo
