On Sat, Jun 15, 2013 at 11:04:28PM +0400, Yuriy Rusinov wrote:
> Postgres 9.1
>
> utf-8
Is this the system locale or the pgcluster encoding? What is the output of the
pg_lsclusters?
Consider the utf8 convertion of those initial scripts if this is not an
option, then just create new cluster with
Hello:
I have one question about prepared statement.
I use Java via JDBC, then send prepared statement to execute.
I thought that the pg_prepared_statments view will have one record after
my execution.
But I can't find.
Is the JDBC's prepared statement differ from SQL execute by prepar
* 高健 (luckyjack...@gmail.com) wrote:
> Is there any common calculation methods for deciding the max_connections
> value?
max_connections is a hard limit and so you'd want to have that higher
than the number of connections you actually expect to have. The general
recommendation is to have the same
Thanks a lot!
I have understand this now.
And the following:
>In general you only want to have as many actual connections to PG
>as you have CPU cores in your database server.
This made me consider the appropriate value for max_conennections.
This might be another topic I think.
I am wo
On Fri, Jun 14, 2013 at 2:25 PM, Moshe Jacobson wrote:
> My database is total around 100 gigs of data, and I have 50 gigs free on
> the volume, yet I get this error message. It was a simple join. Is there a
> way to see more information on why I got this error?
>
How big are the particular table
El 14/06/13 18:25, Moshe Jacobson escribió:
My database is total around 100 gigs of data, and I have 50 gigs free on
the volume, yet I get this error message. It was a simple join. Is there
a way to see more information on why I got this error?
Forgot to say. A low value of work_mem will make i
El 14/06/13 18:25, Moshe Jacobson escribió:
My database is total around 100 gigs of data, and I have 50 gigs free on
the volume, yet I get this error message. It was a simple join. Is there
a way to see more information on why I got this error?
Hash-joins can use a lot of space on temp files. T
El 09/06/13 18:15, Markus Renner escribió:
Hello everybody,
since postgresql 9.2.x it seems such 32bit libs are gone for 64bit
hosts on repository-level. In other words. They are not install-able
via yum. I've recently installed postgresql92* from
pgdg-centos92-repository. I used pgdg-centos92-