On 11.12.2012 21:11, Andres Freund wrote:
Now that I have read some of that code, I am currently unsure how the
current implementation of this can cooperate with translation, even when
used from the backend?
Hmm, there was a gettext() call missing from report_invalid_record.
That's where the
On 12 December 2012 20:57, Tom Lane t...@sss.pgh.pa.us wrote:
SET STATISTICS 0 seems like a sufficient solution for people who don't
trust the have_column_privilege() protection in the pg_stats view.
The point here is that a user may *have* privilege on the column and
have rights to see some,
2012/12/12 Tom Lane t...@sss.pgh.pa.us:
Simon Riggs si...@2ndquadrant.com writes:
Currently, ANALYZE collects data on all columns and stores these
samples in pg_statistic where they can be seen via the view pg_stats.
Only if you have appropriate privileges.
In some cases we have data that
On 13 December 2012 03:51, Tom Lane t...@sss.pgh.pa.us wrote:
Yes, this does seem like a problem for upgrades from 9.2 to 9.3? We can
have pg_dump --binary-upgrade set these, or have ANALYZE set it. I
would prefer the later.
ANALYZE does not set that value, and is not going to start doing
At 2012-11-13 23:32:15 -0500, pete...@gmx.net wrote:
I noticed we don't implement the recursive view syntax, even though
it's part of the standard SQL feature set for recursive queries.
Here is a patch to add that. It basically converts
CREATE RECURSIVE VIEW name (columns) AS SELECT ...;
On 12/13/2012 12:35:14 AM, Karl O. Pinc wrote:
On 12/12/2012 11:04:53 PM, Josh Kupershmidt wrote:
On Wed, Dec 12, 2012 at 8:14 AM, Karl O. Pinc k...@meme.com wrote:
On 12/11/2012 10:25:43 PM, Josh Kupershmidt wrote:
On Tue, Dec 11, 2012 at 11:46 AM, Karl O. Pinc k...@meme.com
wrote:
On Thu, Dec 7, 2012 at 7:56 PM, Hari babu
haribabu(dot)kommi(at)Huawei(dot)com wrote:
On Thu, Dec 6, 2012 at 8:52 PM, Merlin Moncure mmonc...@gmail.com wrote:
Thanks for that -- that's fairly comprehensive I'd say. I'm quite
interested in that benchmarking framework as well. Do you need
On Thu, Dec 13, 2012 at 6:36 PM, Hari Babu haribabu.ko...@huawei.comwrote:
On Thu, Dec 7, 2012 at 7:56 PM, Hari babu
haribabu(dot)kommi(at)Huawei(dot)com wrote:
On Thu, Dec 6, 2012 at 8:52 PM, Merlin Moncure mmonc...@gmail.com
wrote:
Thanks for that -- that's fairly comprehensive
On Thu, Dec 13, 2012 at 09:40:40AM +, Simon Riggs wrote:
On 13 December 2012 03:51, Tom Lane t...@sss.pgh.pa.us wrote:
Yes, this does seem like a problem for upgrades from 9.2 to 9.3? We can
have pg_dump --binary-upgrade set these, or have ANALYZE set it. I
would prefer the later.
Hey libpq-fans,
i have question compiling libpq on windows (VS2010 32 and 64bit) with SSL
support.
I downloaded the latest source of
postgres http://www.postgresql.org/ftp/source/v9.2.2/ and also the OpenSSL
Win64 v1.0.1c http://slproweb.com/products/Win32OpenSSL.html .
I ran nmake in libpq
On Thu, Dec 13, 2012 at 7:06 AM, Hari Babu haribabu.ko...@huawei.com wrote:
Please find the review of the patch.
Thanks for detailed review!
Basic stuff:
- Patch applies with offsets.
- Compiles cleanly with no warnings
- Regression Test pass.
Code Review:
-
On 13 December 2012 03:51, Tom Lane t...@sss.pgh.pa.us wrote:
ANALYZE does not set that value, and is not going to start doing so,
because it doesn't scan enough of the table to derive a trustworthy
value.
I'm slightly surprised by your remarks here, because the commit
message where the
Heikki Linnakangas wrote:
On 11.12.2012 21:11, Andres Freund wrote:
Now that I have read some of that code, I am currently unsure how the
current implementation of this can cooperate with translation, even when
used from the backend?
Hmm, there was a gettext() call missing from
Hi,pgsql-hackers,
I'm not sure whether it is a bug of using spgist index or not .
OS Version:
CentOS release 6.2 (Final)
PostgreSQL Version:
postgres=# select version();
version
--
On 12-12-12 06:20 AM, Andres Freund wrote:
Possible solutions:
1) INIT_LOGICAL_REPLICATION waits for an answer from the client that
confirms that logical replication initialization is finished. Before
that the walsender connection cannot be used for anything else.
2) we remove the snapshot as
=?utf-8?B?5p2O5rW36b6Z?= hailong...@qunar.com writes:
We have lots data to insert in that table which have the spgist index,
may be the spgist index have a bug on a heavy write condition?
Perhaps, but you certainly haven't provided any information that would
help anyone to fix the bug. Can you
Hi Peter!
Thanks for the review, you raise many noteworthy points. This is going
to be a long mail...
On 2012-12-13 00:05:41 +, Peter Geoghegan wrote:
I'm very glad that you followed my earlier recommendation of splitting
your demo logical changeset consumer into a contrib module, in the
On 2012-12-13 18:29:00 +0100, Andres Freund wrote:
On 2012-12-13 00:05:41 +, Peter Geoghegan wrote:
Initialisation means finding a free “logical slot” from shared memory,
then looping until the new magic xmin horizon for logical walsenders
(stored in their “slot”) is that of the weakest
On 2012-12-13 11:02:06 -0500, Steve Singer wrote:
On 12-12-12 06:20 AM, Andres Freund wrote:
Possible solutions:
1) INIT_LOGICAL_REPLICATION waits for an answer from the client that
confirms that logical replication initialization is finished. Before
that the walsender connection cannot be
Hi, Jeff!
Thanks a lot for review!
On Mon, Dec 10, 2012 at 11:21 PM, Jeff Davis pg...@j-davis.com wrote:
It looks like there are still some problems with this patch.
CREATE TABLE foo(ir int4range);
insert into foo select 'empty' from generate_series(1,1);
insert into foo select
Hi!
On Sat, Dec 8, 2012 at 7:05 PM, Andres Freund and...@2ndquadrant.comwrote:
I notice there's no documentation about the new reloption at all?
Thanks for notice! I've added small description to docs in the attached
patch.
--
With best regards,
Alexander Korotkov.
Hi!
On Sun, Nov 4, 2012 at 11:41 PM, Jeff Davis pg...@j-davis.com wrote:
On Fri, 2012-11-02 at 12:47 +0400, Alexander Korotkov wrote:
Right version of patch is attached.
* In bounds_adjacent, there's no reason to flip the labels back.
Fixed.
* Comment should indicate more explicitly
On Mon, Dec 3, 2012 at 4:31 PM, Alexander Korotkov aekorot...@gmail.comwrote:
Actually, I generally dislike path matrix for same reasons. But:
1) Output graphs could contain trigrams which are completely useless for
search. For example, for regex /(abcdefgh)*ijk/ we need only ijk trigram
On Tue, Dec 11, 2012 at 10:20 PM, Tom Lane t...@sss.pgh.pa.us wrote:
This is why the pg_dump master process executes a
lock table table in access share mode
for every table, so your commands would all block.
A lock doesn't protect against schema changes made before the lock was
taken. The
On 2012-12-13 17:11:31 -0500, Robert Haas wrote:
On Tue, Dec 11, 2012 at 10:20 PM, Tom Lane t...@sss.pgh.pa.us wrote:
This is why the pg_dump master process executes a
lock table table in access share mode
for every table, so your commands would all block.
A lock doesn't protect against
On Thu, Dec 13, 2012 at 3:03 PM, Andres Freund and...@2ndquadrant.com wrote:
It moves a computation of the sort of:
result -= vacuum_defer_cleanup_age;
if (!TransactionIdIsNormal(result))
result = FirstNormalTransactionId;
inside ProcArrayLock. But I can't really imagine that to be
On 2012-12-13 17:29:06 -0500, Robert Haas wrote:
On Thu, Dec 13, 2012 at 3:03 PM, Andres Freund and...@2ndquadrant.com wrote:
It moves a computation of the sort of:
result -= vacuum_defer_cleanup_age;
if (!TransactionIdIsNormal(result))
result = FirstNormalTransactionId;
inside
On Thu, Dec 13, 2012 at 5:25 PM, Andres Freund and...@2ndquadrant.com wrote:
That would solve the consistency problem, yes. Would we need a special
kind of permission for this? I would say superuser/database owner only?
Yeah, I doubt we would need a whole new permission for it, but it
would
Robert Haas robertmh...@gmail.com writes:
On Thu, Dec 13, 2012 at 5:25 PM, Andres Freund and...@2ndquadrant.com wrote:
That would solve the consistency problem, yes. Would we need a special
kind of permission for this? I would say superuser/database owner only?
Yeah, I doubt we would need a
On Thu, Dec 13, 2012 at 5:55 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Thu, Dec 13, 2012 at 5:25 PM, Andres Freund and...@2ndquadrant.com
wrote:
That would solve the consistency problem, yes. Would we need a special
kind of permission for this? I
On Wed, Dec 12, 2012 at 3:51 PM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Tom Lane t...@sss.pgh.pa.us writes:
Maybe we could just append to it how to remove such an event trigger,
which is easy to do because you can't target an event trigger related
command with event triggers, so the
Robert Haas robertmh...@gmail.com writes:
On Wed, Dec 12, 2012 at 3:51 PM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Robert, does that ring a bell to you? I'm going to crawl the archives
tomorrow if not
Yeah, I'm pretty sure you can't set event triggers of any kind on
event triggers.
On 13 December 2012 22:37, Andres Freund and...@2ndquadrant.com wrote:
On 2012-12-13 17:29:06 -0500, Robert Haas wrote:
On Thu, Dec 13, 2012 at 3:03 PM, Andres Freund and...@2ndquadrant.com
wrote:
It moves a computation of the sort of:
result -= vacuum_defer_cleanup_age;
if
On Thu, Dec 13, 2012 at 6:05 AM, Karl O. Pinc k...@meme.com wrote:
On 12/13/2012 12:35:14 AM, Karl O. Pinc wrote:
On 12/12/2012 11:04:53 PM, Josh Kupershmidt wrote:
On Wed, Dec 12, 2012 at 8:14 AM, Karl O. Pinc k...@meme.com wrote:
On 12/11/2012 10:25:43 PM, Josh Kupershmidt wrote:
On
On 12/13/2012 07:37:27 PM, Josh Kupershmidt wrote:
On Thu, Dec 13, 2012 at 6:05 AM, Karl O. Pinc k...@meme.com wrote:
On 12/13/2012 12:35:14 AM, Karl O. Pinc wrote:
On 12/12/2012 11:04:53 PM, Josh Kupershmidt wrote:
On Wed, Dec 12, 2012 at 8:14 AM, Karl O. Pinc k...@meme.com
wrote:
On Thu, Dec 13, 2012 at 7:24 PM, Karl O. Pinc k...@meme.com wrote:
The problem is that the pg man pages would then have a
syntax different from all the other man pages in the system,
which all have ... outside of square braces.
See man cat, e.g.
FWIW, `man cat` on my OS X machine has
On Fri, Dec 14, 2012 at 2:29 AM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Dec 13, 2012 at 3:03 PM, Andres Freund and...@2ndquadrant.com
wrote:
It moves a computation of the sort of:
result -= vacuum_defer_cleanup_age;
if (!TransactionIdIsNormal(result))
result =
hi,
The problem is not always appear on our system, we can't find a way to
reproduce it.
After rebuild the index with btree, the problem is disappear
at 2012-12-14 00:16, Tom Lane wrote:
=?utf-8?B?5p2O5rW36b6Z?= hailong...@qunar.com writes:
We have lots data to insert in that table which
On 12/13/2012 09:24:24 PM, Josh Kupershmidt wrote:
On Thu, Dec 13, 2012 at 7:24 PM, Karl O. Pinc k...@meme.com wrote:
As a fallback I'd do to the clusterdb, reindexdb, and vacuumdb
syntax summaries what was done to the pg_dump and pg_restore
syntax summaries. Remove all the detail. This
On Wed, 2012-11-14 at 00:21 -0600, Karl O. Pinc wrote:
I'm going to send this in as a single patch
that fixes all the search path related
index entries:
search_path-index.patch
(replaces search_path-normalize.patch
and search_path-securing_v2.patch)
The other configuration
On Thu, Dec 13, 2012 at 9:03 PM, Karl O. Pinc k...@meme.com wrote:
My brain seems to have turned itself on. I went and (re)read
the docbook manual and was able to come up with this,
which works:
arg choice=plain rep=repeatarg choice=opt
group choice=plain
arg
On Tue, 2012-11-06 at 10:57 -0500, Robert Haas wrote:
I did some experimentation with this. It seems that what Tom proposed
here is a lot cleaner than what I proposed previously, while still
increasing usability in many real-world cases. For example, in
unpatched master:
It looks like we
On Tue, 2012-11-27 at 14:24 -0800, Jeff Davis wrote:
On Tue, 2012-11-27 at 15:41 -0500, Robert Haas wrote:
I can't quite see how a non-overloaded flag would work, unless we get
rid of schemas.
It may work to pick the first schema in the search path that has any
functions by that name, and
43 matches
Mail list logo