On 12/15/2013 10:54 PM, Thomas Kellerer wrote:
Both are valid. interval '2' day is the ANSI SQL format though.
oh, really! ah, I stand corrected, didn't realize the units were valid
keywords like that.
--
john r pierce 37N 122W
somewhere on the
Le dimanche 15 décembre 2013 à 10:57 -0500, Andrew Sullivan a écrit :
I thought people'd like to know about this.
Potential submission material for HackerNews maybe? I'm not seeing it
there
https://news.ycombinator.com/news
--
Regards, Vincent
Restoring a plain format dump and a custom format dump of
the same database can lead to different results:
pg_dump organizes the SQL statements it creates in TOC entries.
If a custom format dump is restored with pg_restore, all
SQL statements in a TOC entry will be executed as a single command
Albe Laurenz laurenz.a...@wien.gv.at writes:
Restoring a plain format dump and a custom format dump of
the same database can lead to different results:
pg_dump organizes the SQL statements it creates in TOC entries.
If a custom format dump is restored with pg_restore, all
SQL statements in a
Hi!
I'd like to revisit this issue. What we have noticed that the amount of
memory increase does not really depend on the number of large queries,
but the number of queries in general.
So, can anybody confirm that is is normal for a 9.2 based server
connection to take up 10 times the
Eliott eliott...@gmail.com writes:
So, can anybody confirm that is is normal for a 9.2 based server
connection to take up 10 times the connection specific memory that 8.3
used to need?
I'm sure there's been some bloat over time, but I can't offhand think of
a reason for it to be 10X more
Hi all,
The past few days I’ve been encountering the following error, followed by a
full db restart and recovery
2013-12-16 07:12:53 GMT LOG: could not write temporary statistics file
pg_stat_tmp/pgstat.tmp: No space left on device
This occurs at a time of moderate load, during the same set
On Mon, Dec 16, 2013 at 2:57 PM, Tim Kane tim.k...@gmail.com wrote:
Hi all,
The past few days I’ve been encountering the following error, followed by
a full db restart and recovery
2013-12-16 07:12:53 GMT LOG: could not write temporary statistics file
pg_stat_tmp/pgstat.tmp: No space
On Mon, Dec 16, 2013 at 2:08 AM, John R Pierce pie...@hogranch.com wrote:
On 12/15/2013 10:54 PM, Thomas Kellerer wrote:
Both are valid. interval '2' day is the ANSI SQL format though.
oh, really! ah, I stand corrected, didn't realize the units were valid
keywords like that.
Me neither.
2013/12/13 Kevin Grittner kgri...@ymail.com
Misa Simic misa.si...@gmail.com wrote:
So I wonder - is there some kind of aggregate window function
what does desired results?
Not built in, but PostgreSQL makes it pretty easy to do so. With a
little effort to define your own aggregate
On Mon, Dec 16, 2013 at 5:57 AM, Tim Kane tim.k...@gmail.com wrote:
Hi all,
The past few days I’ve been encountering the following error, followed by
a full db restart and recovery
2013-12-16 07:12:53 GMT LOG: could not write temporary statistics file
pg_stat_tmp/pgstat.tmp: No space
I would like to build from source, however I would like to integrate
with the scripts included in the ubuntu packages from
https://wiki.postgresql.org/wiki/Apt. Where are the scripts that are
used to build the various relevant packages from presumably these
postgresql sources:
Typo of course:
$ver=9.3
$type=main
./configure --prefix=/usr/lib/postgresql/$ver/
--datarootdir=/usr/share/postgresql/$ver
--sysconfdir=/etc/postgresql/$ver/$type
On Mon, Dec 16, 2013 at 3:47 PM, imagene...@gmail.com
imagene...@gmail.com wrote:
I would like to build from source, however I
http://www.debian.org/doc/manuals/maint-guide/build.en.html
Resolved.
On Mon, Dec 16, 2013 at 3:53 PM, imagene...@gmail.com
imagene...@gmail.com wrote:
Typo of course:
$ver=9.3
$type=main
./configure --prefix=/usr/lib/postgresql/$ver/
--datarootdir=/usr/share/postgresql/$ver
14 matches
Mail list logo