Ok - I agree -
Can somebody help me understand where the row estimates come from on a
nested-loop operation in postgres then?
- Original Message -
From: hubert depesz lubaczewski dep...@depesz.com
To: Jeff Amiel becauseimj...@yahoo.com
Cc: pgsql-general@postgresql.org
On Sun, May 19, 2013 at 8:07 PM, Toby Corkindale
toby.corkind...@strategicdata.com.au wrote:
On 11/05/13 02:25, Merlin Moncure wrote:
On Fri, May 10, 2013 at 11:11 AM, Evan D. Hoffman
evandhoff...@gmail.com wrote:
Not sure of your space requirements, but I'd think a RAID 10 of 8x or
more
On Mon, May 20, 2013 at 11:01 PM, Jeff Amiel becauseimj...@yahoo.com wrote:
Ok - I agree -
Can somebody help me understand where the row estimates come from on a
nested-loop operation in postgres then?
In case you haven't noticed already in the documentation, there are
following lines:
...
I also found one other discussion which has similar issues addressed:
http://postgresql.1045698.n5.nabble.com/Bogus-nestloop-rows-estimate-in-8-4-7-td5710254.html
--
Amit Langote
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Thanks much!
(sorry for top-posting, yahoo email sucks)
- Original Message -
From: Amit Langote amitlangot...@gmail.com
To: Jeff Amiel becauseimj...@yahoo.com
Cc: dep...@depesz.com dep...@depesz.com; pgsql-general@postgresql.org
pgsql-general@postgresql.org
Sent: Monday, May 20, 2013
On Tue, May 21, 2013 at 12:43 AM, Jeff Amiel becauseimj...@yahoo.com wrote:
Thanks much!
(sorry for top-posting, yahoo email sucks)
I wonder if you could arrive at some conclusions with the statistics
(pg_stats) you have and the join selectivity formulas described in the
referred documentation
Thank you Tom
On 05/19/2013 01:26 AM, Tom Lane wrote:
=?UTF-8?B?Tmlja2xhcyBBdsOpbg==?= nicklas.a...@jordogskog.no writes:
Perhaps you could construct your usage like this:
post_process_function(aggregate_function(...), fixed_argument)
where the aggregate_function just collects the
Hello,
My objective is to work with postgres from my linux box using C. Am not
sure whether psqlODBC or
libpqhttp://www.postgresql.org/docs/9.2/static/libpq.htmlshould be
used.
I was playing and used libpq successfully but not sure which route to go
and whats the difference.
Also Can you please
Also adding the pgsql-admin alias.
Regards...
On 20/05/13 15:12, David Boreham wrote:
On 5/19/2013 7:19 PM, Toby Corkindale wrote:
On 13/05/13 11:23, David Boreham wrote:
btw we deploy on CentOS6. The only things we change from the default
are:
1. add relatime,discard options to the mount (check whether the most
recent CentOS6 does this
On 21/05/13 00:16, Merlin Moncure wrote:
On Sun, May 19, 2013 at 8:07 PM, Toby Corkindale
toby.corkind...@strategicdata.com.au wrote:
On 11/05/13 02:25, Merlin Moncure wrote:
On Fri, May 10, 2013 at 11:11 AM, Evan D. Hoffman
evandhoff...@gmail.com wrote:
Not sure of your space requirements,
Sent from my iPad
On 21-May-2013, at 6:15, Dev Kumkar devdas.kum...@gmail.com wrote:
Hello,
My objective is to work with postgres from my linux box using C. Am not sure
whether psqlODBC or libpq should be used.
I was playing and used libpq successfully but not sure which route to go and
On Mon, May 20, 2013 at 9:12 PM, Atri Sharma atri.j...@gmail.com wrote:
If you wish to work in C,then,I would suggest libpq.I would wait for more
replies on this,as I have little knowledge
about psqlODBC.
Thanks for the comments. Yes objective is to work in C and found libpq
useful but am
On 5/20/2013 10:11 PM, Dev Kumkar wrote:
On Mon, May 20, 2013 at 9:12 PM, Atri Sharma atri.j...@gmail.com
mailto:atri.j...@gmail.com wrote:
If you wish to work in C,then,I would suggest libpq.I would wait
for more replies on this,as I have little knowledge
about psqlODBC.
Thanks
Hello,
I intend to create some native data types for PostgreSQL, but since our servers
run on Windows and Linux, I would have to compile the libraries for Windows and
for Linux (will need nothing else than the standard C libs). Our build server
is a Debian 6 Linux system. Is there a way to
15 matches
Mail list logo