etc.
IMHO, the problem with these estimations is that they are horribly off.
I've searched the archives, and it seems that PostgreSQL's users are bitten
by it sometimes,
like: http://www.postgresql.org/message-id/4583.1358289...@sss.pgh.pa.us.
-
WBR, Yaroslav Schekin.
--
View this message i
> My simple test (using MCVs) is below ...
I've posted wrong second query in the test, should have been:
EXPLAIN SELECT * FROM t2 WHERE n >= 0 AND n <= 2
-- rows=12
-
WBR, Yaroslav Schekin.
--
View this message in context:
http://postgresql.nabble.com/Row-count-estimation-
in.
*/
binfrac = (val - low) / (high - low);
-
And now I'm stuck. Can ">" operators can be distinguished from ">="
operators at this point?
-
WBR, Yaroslav Schekin.
--
View this message in context:
http://postgresql.nabble.com/Row-count-estimation-bug-
On 25/09/2010, at 1:11 AM, Craig Ringer wrote:
On 24/09/2010 8:40 PM, Raymond O'Donnell wrote:
On 24/09/2010 13:21, kongs...@stud.ntnu.no wrote:
What version of PG was it?
The "PG_VERSION" file = 8.3
OK, well at least it's not an ancient version that's not available
any
more. :-)
As Cra
On 14/09/2010, at 10:37 AM, Yaroslav Tykhiy wrote:
On 14/09/2010, at 12:41 AM, Tom Lane wrote:
Yaroslav Tykhiy writes:
[...]
I think the major problem you're having is that the planner is
completely clueless about the selectivity of the condition
"substring"(v.heade
Hi Tom,
On 14/09/2010, at 12:41 AM, Tom Lane wrote:
Yaroslav Tykhiy writes:
-> Bitmap Heap Scan on dbmail_headervalue v
(cost=1409.82..221813.70 rows=2805 width=16) (actual
time=28543.411..28623.623 rows=1 loops=1)
Recheck C
On 14/09/2010, at 8:56 AM, Tom Lane wrote:
Bruce Momjian writes:
Yaroslav Tykhiy wrote:
SELECT * FROM foo.bar WHERE bar.a=1;
^^^ this means foo.bar
Do you think it's a feature or a bug? :-)
Feature, and SQL-standard behavior.
It might be worth pointin
Hi Martin,
Thank you for your response!
On 13/09/2010, at 10:49 AM, Martin Gainty wrote:
a cursory look of the plan details a FTS on dbmail_headername
invoked by the JOIN clause
JOIN dbmail_headername n ON v.headername_id=n.id
you would accelerate the seek appreciably by placing indexes on b
Hi there,
Sorry but I've got yet another issue to discuss today, this time that
on schema search path. In fact it may not be a bug, but it may be
worth a note in the documentation.
It seems that if the table in SELECT FROM has an explicit schema
specifier, further references to the same
Hi all,
I'm seeing a funny behaviour in Postgresql 8.4.4. Namely, a query can
be executed using either of two different query plans, one taking a
few milliseconds and the other, tens of seconds. The work_mem setting
doesn't seem to affect it -- tried to increase or decrease it by 2 or
4
On Thu, Aug 19, 2010 at 11:22:15PM -0400, Tom Lane wrote:
> Sam Nelson writes:
> > Here's the output from pg_controldata:
>
> > $ pg_controldata `pwd`
> > WARNING: Calculated CRC checksum does not match value stored in file.
> > Either the file is corrupt, or it has a different layout than this p
On Sat, Aug 21, 2010 at 12:45:44PM -0400, Bruce Momjian wrote:
> Derrick Rice wrote:
> > I've been reading up on the documentation for WAL shipping and warm standby
> > configuration. One concern that I have (a common one, I'm sure) is that it
> > seems that after bringing a standby server up as pr
Hi,
On 21/06/2010, at 3:37 AM, Raymond O'Donnell wrote:
On 20/06/2010 17:34, Elior Soliman wrote:
Hello,
My company looking for some solution for High availability with
Postgres.
There's quite a bit of information in the documentation here:
http://www.postgresql.org/docs/8.4/static/high
Hi David,
On 22/10/2009, at 2:52 PM, David Jantzen wrote:
I want to run a warm standby scenario by you. I'm pretty sure it'll
work, but it's a very large database so even the slightest mistake can
mean a major setback.
Scenario:
Server A is the provider node, shipping WAL files to Server B.
On 06/10/2009, at 11:51 PM, Geoffrey wrote:
We are currently using WAL shipping to have a hot spare of our
databases. We want to add another node to this configuration. The
question is, what is the best way to go about this?
Currently, our script checks to see if the WAL file already exis
On 09/09/2009, at 10:43 AM, John R Pierce wrote:
纪晓曦 wrote:
Can I save images in the postgres? How to define? Does the format
matters? Can I save JPG/PNG?How?
you can save images as BYTEA data, and the format is totally up to
your application, as postgres just treats it as a block of bytes
On 09/09/2009, at 9:02 AM, David W Noon wrote:
On Tue, 8 Sep 2009 14:25:20 -0700, Scott Frankel wrote about [GENERAL]
where clauses and multiple tables:
Is it possible to join tables in the where clause of a statement?
[snip]
Given a statement as follows:
SELECT foo.foo_id, foo.name
FROM
On 31/08/2009, at 6:16 PM, Sébastien Lardière wrote:
On 28/08/2009 18:14, Simon Riggs wrote:
On Fri, 2009-08-28 at 17:54 +0200, Sébastien Lardière wrote:
Since this moment, the slave didn't make any checkpoint.
Now, we know why. Thanks a lot !
But how can i fix it ?
Current issue: Rebuild
On 21/08/2009, at 12:40 PM, Seth Gordon wrote:
Yaroslav Tykhiy wrote:
By the way, `chkdsk' in Windows or `fsck' in Unix can, in a way, be
a _source_ of file loss if the file metadata got damaged badly,
e.g., by a system crash, and the file node has to be cleared. So
I'
On 20/08/2009, at 7:24 PM, vinny wrote:
I can't really think of any real reason to put the field at a
particular
position, applications
don't reallty care about the order of fields.
... unless an application is brain-damaged by its using a wildcard
select, which is a well-known no-no even
Hi there,
On 19/08/2009, at 8:38 PM, Craig Ringer wrote:
On 19/08/2009 6:26 PM, Alan Millington wrote:
2009-08-19 03:06:45 ERROR: could not read block 0 of relation
1663/52752/52896: No such file or directory
Clearly something is amiss, but I don't know what. I should be
grateful
for any
On 18/08/2009, at 9:36 AM, Bryan Murphy wrote:
Ok, I've asked this a few times, but nobody ever responded. I think
I finally got it though, could somebody confirm my logic?
Basically, you setup a chain of servers, and when fails you
replicate to the next link in the chain, like so:
Mast
On 08/07/2009, at 8:39 PM, Alban Hertroys wrote:
On Jul 8, 2009, at 2:50 AM, Yaroslav Tykhiy wrote:
Hi All,
I have a mid-size database (~300G) used as an email store and
running on a FreeBSD + ZFS combo. Its PG_DATA is on ZFS whilst
xlog goes to a different FFS disk. ZFS prefetch was
Hi All,
I have a mid-size database (~300G) used as an email store and running
on a FreeBSD + ZFS combo. Its PG_DATA is on ZFS whilst xlog goes to a
different FFS disk. ZFS prefetch was enabled by default and disk time
on PG_DATA was near 100% all the time with transfer rates heavily
bia
DimitryASuplatov wrote:
My task is to store a lot (10^5) of small ( <10 MB) text files in the
database with the ability to restore them back to the hard drive on
demand.
I cannot but ask the community a related question here: Can such
design, that is, storing quite large objects of varying si
David Fetter wrote:
On Thu, Jun 04, 2009 at 11:11:29AM -0400, Bruce Momjian wrote:
Jennifer Trey wrote:
Hi,
What file should I be working with?
Just shut down the server and move the directory whever you want and
restart the server. There are no file contents that need changing.
Of course sho
Hi All,
Let's consider the following case: WAL segments from a master have
been shipped to N warm standby servers, and now the master fails.
Using this or that mechanism, one of the warm standbys takes over and
becomes the new master. Now the question is what to do with the other
N-1 warm st
27 matches
Mail list logo
