On Sat, Mar 17, 2012 at 10:45 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Here is v11. This version is mainly updated to add pg_upgrade support,
as discussed. It also contains the README file that was posted earlier
(plus wording fixes per Bruce), a couple of bug fixes, and some
Hello,
Here is something we'd like to have:
http://archives.postgresql.org/pgsql-hackers/2012-01/msg00650.php
As we are quite busy and this issue hasn't a high priority, we haven't followed
it until now :-(
I'm only a Postgres user, not a hacker, so I don't have the knowledge to
On 19 mar 2012, at 22.45, Merlin Moncure wrote:
one pl/java based project that IMO is just screaming to be done is a
pl/java based FDW (wrapping JDBC) that would approximately reproduce
dblink...maybe with some extra features geared towards ETL type jobs
like a row based callback for
Il giorno mar, 20/03/2012 alle 11.16 +, Peter Geoghegan ha scritto:
On 20 March 2012 10:53, Marco Nenciarini
marco.nenciar...@2ndquadrant.it wrote:
alert.c: In function ‘dbms_alert_defered_signal’:
alert.c:839:33: error: dereferencing pointer to incomplete type
make: *** [alert.o]
On 20 mar 2012, at 13.08, Heikki Linnakangas wrote:
On 20.03.2012 11:10, Claes Jakobsson wrote:
Personally I'd love a type 2 JDBC driver for PostgreSQL.
Why?
listen/notify over SSL for example unless that's been fixed in the JDBC driver
recently. And I'm sure there are other things in
i want see the log of INSERT, SELECT, DELETE... within postgresql v9.1.3
i'm so sorry, my english level...
how can i see that.
transaction log?... or other thing...?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-can-i-see-the-log-tp5583083p5583083.html
Sent
Hi,
[...]
Placing a sync (i.e., the strongest Power barrier) accordingly would,
however,
still be insufficient for the second problem, as it would only fix the
reordering of read-read pairs by Worker 1 and the store atomicity issue from
Worker 0. But the writes on Worker 0 could still
Hi,
while working on a support case I stumbled upon a bug in pg_upgrade.
Upgrade fails with No such file or directory when a database is
moved to a non-default tablespace and contains a table that is moved
to pg_default. The cause seems to be that the following test
incorrectly equates empty
Someone has approached the JDBC list to do some work on the driver as
a GSOC project.
I need to know what is involved in mentoring and how to get the
project approved
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list
This is a bit of a corner case in all honesty, but if you have a short
table (under 20 rows), the 10% heuristic used that decides whether
distinct values scale with the row count will result in rather odd
values for stadistinct in pg_statistic, such as '-0.2' or '-0.67',
rather than the
Hello all ... again !
SHORT INTRODUCTION
===
Remember me? A couple of years ago (maybe 10) I created the PgAccess
package for managing PostgreSQL!
Since than I have done many things, all of them related to PostgreSQL, of
course!
Our company is managing the National Animal Tracking
On Sun, Mar 25, 2012 at 7:14 AM, Constantin Teodorescu
braila...@gmail.com wrote:
This paper analyzes the scalability of seven system applications (Exim,
memcached, Apache, PostgreSQL, gmake, Psearchy, and MapReduce) running on
Linux on a 48-core computer. Except for gmake, all applications
On Sat, Mar 24, 2012 at 12:17 AM, Dan McGee d...@archlinux.org wrote:
This is a bit of a corner case in all honesty, but if you have a short
table (under 20 rows), the 10% heuristic used that decides whether
distinct values scale with the row count will result in rather odd
values for
On Sun, Mar 25, 2012 at 6:11 AM, Marc Mamin m.ma...@intershop.de wrote:
Hello,
Here is something we'd like to have:
http://archives.postgresql.org/pgsql-hackers/2012-01/msg00650.php
As we are quite busy and this issue hasn't a high priority, we haven't
followed it until now :-(
I'm only
Robert Haas robertmh...@gmail.com writes:
The bit about maybe not getting both t and f as MCVs on a Boolean does
seem a little worrying, but I'm not sure whether it actually affects
query planning in a materially negative way. Can you demonstrate a
case where it matters?
If we were trying to
Every so often buildfarm animals (nightjar and raven recently, for
example) report failures on starting up the postmaster. It appears that
these failures are due to the postmaster not creating the pid file
within 5 seconds, and so the logic in commit
0bae3bc9be4a025df089f0a0c2f547fa538a97bc
Thanks.. I'll keep those issues in mind.
On Sat, Mar 24, 2012 at 6:18 PM, Tatsuo Ishii is...@postgresql.org wrote:
Well, you'd have to start by demonstrating the benefit of it. The
advantage of query caches in proxies and clients is well-known, because
you
can offload some of the work
Andrew Dunstan and...@dunslane.net writes:
Every so often buildfarm animals (nightjar and raven recently, for
example) report failures on starting up the postmaster. It appears that
these failures are due to the postmaster not creating the pid file
within 5 seconds, and so the logic in
On Sun, Mar 25, 2012 at 18:59, Tom Lane t...@sss.pgh.pa.us wrote:
Andrew Dunstan and...@dunslane.net writes:
Every so often buildfarm animals (nightjar and raven recently, for
example) report failures on starting up the postmaster. It appears that
these failures are due to the postmaster not
On Friday, March 23, 2012 04:32:02 PM Dimitri Fontaine wrote:
I would like to get back on code level review now if at all possible,
and I would integrate your suggestions here into the next patch revision
if another one is needed.
Ok, I will give it another go.
Btw I just wanted to alert you
lekon wrote:
i want see the log of INSERT, SELECT, DELETE... within postgresql
v9.1.3
The pgsql-hackers list is for discussions about development of the
PostgreSQL datatbase system; discussions about how to use it should
go to another list. The particular question would be appropriate for
On 3/23/12 1:58 PM, Dave Cramer wrote:
Someone has approached the JDBC list to do some work on the driver as
a GSOC project.
I need to know what is involved in mentoring and how to get the
project approved
I've approved you as a mentor. I suggest also joining the
pgsql-students mailing
On 3/23/12 7:38 AM, Robert Haas wrote:
And here are the latency results for 95th-100th percentile with
checkpoint_timeout=16min.
ckpt.master.13: 1703, 1830, 2166, 17953, 192434, 43946669
ckpt.master.14: 1728, 1858, 2169, 15596, 187943, 9619191
ckpt.master.15: 1700, 1835, 2189, 22181, 206445,
On 3/22/12 2:13 PM, Stephen Frost wrote:
Greetings,
I've recently become a bit annoyed and frustrated looking at this in
top:
23296 postgres 20 0 3341m 304m 299m S 12 0.9 1:50.02 postgres: sfrost
gis [local] COPY waiting
24362 postgres 20 0 3353m 298m 285m D 12 0.9
Jim Nasby j...@nasby.net writes:
On 3/22/12 2:13 PM, Stephen Frost wrote:
Has anyone been working on or considering how to improve the logic
around doing extends on relations to perhaps make larger extensions
for larger tables? Or make larger extensions when tables are growing
very quickly?
On Fri, Mar 23, 2012 at 11:11 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Are you going to provide a rebased version?
Rebased version attached, this patch also includes Robert's earlier suggestions.
parallel_pg_dump_5.diff.gz
Description: GNU Zip compressed data
--
Sent via
() is a fallback.
Regards,
Jeff Davis
initdb-fsync-20120325.patch.gz
Description: GNU Zip compressed data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Friday, March 16, 2012 10:40:46 AM Dimitri Fontaine wrote:
This will have the effect of calling triggers outside of alphabetic
order. I don't think thats a good idea even if one part is ANY and the
other a specific command.
I don't think there is any reason anymore to separate the two?
28 matches
Mail list logo