Dear sirs,
how I have to modify postgresql.conf to increase the number of concurrent
connection over the value 100 setted by by default?
I tryied to modify this value but the server get an error and not start.
My version is 8.2.5 on Linux Fedora 8.
The PC has 2 GB ram and Celeron 2.8 processor.
On 10/01/2008, Matthew T. O'Connor [EMAIL PROTECTED] wrote:
Pavel Stehule wrote:
pgbench test - default configuration
Verze 7.3.15 7.4.13 8.0.8 8.1.4 8.2.beta1 8.3beta1
tps 311 340 334 398 423 585
but pgbench is simple test and thise numbers hasnot great
am Thu, dem 10.01.2008, um 9:12:27 +0100 mailte dfx folgendes:
Dear sirs,
how I have to modify postgresql.conf to increase the number of concurrent
connection over the value 100 setted by by default?
I tryied to modify this value but the server get an error and not start.
What exactly
On Thu, 2008-01-10 at 07:52 +0100, Gábor Farkas wrote:
the remaining 3 were only idle-in-transaction at that point. so if i
would keep checking for idle-in-transaction processes, the list of them
would keep changing.
are you saying, that a process should NEVER be idle-in-transaction? not
Simon Riggs wrote:
also, even if it is wrong, can an 'idle-in-transaction' connection that
was opened today block the vacuuming of rows that were deleted yesterday?
Yes, if the rows were deleted after the connection started.
to avoid any potential misunderstandings, i will summarize the
2008/1/8, Clodoaldo [EMAIL PROTECTED]:
2008/1/8, Alvaro Herrera [EMAIL PROTECTED]:
Clodoaldo escribió:
8.2:
Trigger for constraint datas: time=14231.240 calls=880691
Total runtime: 356862.302 ms
(12 rows)
Time: 357750.531 ms
8.3:
Trigger for constraint datas:
first: thanks a lot for your answer. it already helped me a lot, but i still
have some questions:
Am Mittwoch, 9. Januar 2008 21:16 schrieb Kris Jurka:
On Wed, 9 Jan 2008, [EMAIL PROTECTED] wrote:
- I know there is a PREPARE Statement in Postgresql and read the docs.
- in PostgresqlJDBC i
On Wed, Jan 09, 2008 at 03:28:04PM +0100, Ivan Sergio Borgonovo wrote:
Let me consider an everyday use where count() looks as the most
obvious solution: paging.
I search trough a table and I need to know which is the last page.
There's an often overlooked solution to this. Let's say your
In article [EMAIL PROTECTED],
Chris Browne [EMAIL PROTECTED] writes:
There may be a further optimization to be had by doing a
per-statement trigger that counts the number of INSERTs/DELETEs done,
so that inserting 30 tuples (in the table being tracked) leads to
adding a single tuple with
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10 Jan 2008, at 11:18, Gábor Farkas wrote:
Simon Riggs wrote:
also, even if it is wrong, can an 'idle-in-transaction'
connection that was opened today block the vacuuming of rows that
were deleted yesterday?
Yes, if the rows were deleted
If possible can you send the data dump of these tables.
usuarios_temp , usuarios_indice ?
Thanks,
Gokul.
On Jan 10, 2008 4:00 PM, Clodoaldo [EMAIL PROTECTED] wrote:
2008/1/8, Clodoaldo [EMAIL PROTECTED]:
2008/1/8, Alvaro Herrera [EMAIL PROTECTED]:
Clodoaldo escribió:
8.2:
On Wed, Jan 09, 2008 at 04:59:45PM -0600, Scott Marlowe wrote:
On Jan 9, 2008 3:57 PM, Hervé Piedvache [EMAIL PROTECTED] wrote:
Jan 9 20:30:48 db2 kernel: Free swap = 15623168kB
Jan 9 20:30:48 db2 kernel: Total swap = 15623172kB
Jan 9 20:30:48 db2 kernel: Free swap: 15623168kB
Albe Laurenz [EMAIL PROTECTED] escribió: Sebastián Baioni wrote:
Every day we run a Windows Programmed pg_dump, it used to
work fine with PostgreSQL 8.0, but since we installed the new
version we are not able to make a backup. We tried to make a
whole database backup and it never ends. We
On 1/10/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I have not found anything about preparing unnamed statements. What
does it mean?
Unnamed statements are what the driver uses before it hits the
prepareThreshold limit. Once it has determined the statement will be
reused many
FATAL: XX000: failed to initialize lc_messages to
LOCATION: InitializeGUCOptions, guc.c:2666
Typically what this means is that you have an improper setting of LANG
or LC_ALL in your environment (improper meaning that it doesn't
match
any of the locales that are actually installed on your
On Thu, 2008-01-10 at 11:18 +0100, Gábor Farkas wrote:
Simon Riggs wrote:
also, even if it is wrong, can an 'idle-in-transaction' connection that
was opened today block the vacuuming of rows that were deleted yesterday?
Yes, if the rows were deleted after the connection started.
FATAL: XX000: failed to initialize lc_messages to
LOCATION: InitializeGUCOptions, guc.c:2666
Typically what this means is that you have an improper setting of LANG
or LC_ALL in your environment (improper meaning that it doesn't
match
any of the locales that are actually installed on your
Hi,
I want format a column in select result:
1.1 = 1.10
Any idea?
Thanks!
Fernando
Abraços,
Fernando
Abra sua conta no Yahoo! Mail, o único sem limite de espaço para
armazenamento!
http://br.mail.yahoo.com/
---(end of broadcast)---
am Thu, dem 10.01.2008, um 10:03:05 -0300 mailte Fernando Xavier folgendes:
Hi,
I want format a column in select result:
1.1 = 1.10
Any idea?
Yes. You can use to_char() or a CAST like
test=*# select 1.1::numeric(10,2);
numeric
-
1.10
(1 row)
Andreas
--
Andreas
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Chris Browne [EMAIL PROTECTED] writes:
There may be a further optimization to be had by doing a
per-statement trigger that counts the number of INSERTs/DELETEs done,
so that inserting 30 tuples (in the table being tracked) leads to
I want format a column in select result:
1.1 = 1.10
Any idea?
Try the to_date() function like
SELECT to_char(1.1, '0.99');
Yours,
Laurenz Albe
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
On Jan 10, 2008 1:37 AM, Ken Johanson [EMAIL PROTECTED] wrote:
Hi all,
I am looking for expertise on how to program the equivalent to this
query, but using the pg_catalog tables, which I understand have fewer
security restrictions than information_schema in some cases:
SELECT column_name
Hello,
I'm trying to create a composite type with an argument, to create one field of
this type like character varying(x), but I don't know if this can be done with
PostgreSQL. I want something like:
CREATE TYPE mytype AS (
tx character varying(x),
t2nd integer
);
I need to
Ignoring the warnings not to use a beta product on a production database I
had been running 8.3beta1. When I saw that it had hit 8.3RC1 I decided to
upgrade and folowing the usual data compatibility within major versions I
did not do a pg_dump, in fact my last dump was when I loaded the beta on
I changed max_connection from 100 to 200 and stop the service.
If I try to start again the service does no start.
What is the max number of connections I can hope to obtain without recompile
the kernel of Fedora 8?
Thank you.
Domenico Formenton
A. Kretschmer wrote:
am Thu, dem
I had this exact problem. I had to in fact compile the pgpool-II source
code rather than yum install pgpool-II.
On Jan 8, 2008 9:55 AM, Tatsuo Ishii [EMAIL PROTECTED] wrote:
Can you provide more info please?
- pgpool version(I assume it's pgpool-II since you use 3 PostgreSQL
servers)
-
Hi Everyone,
I am trying to import data from a backed up PostgreSQL tablespace. The
server which the original data was on has been wiped.
1. I saved the tablespace onto a portable harddrive from the old server.
This contains the tablespace folder (with PG_VERSION file) and a folder
named 225809.
On Jan 8, 11:35 am, [EMAIL PROTECTED] (Tom Lane) wrote:
cdecarlo [EMAIL PROTECTED] writes:
I'm new to pl/pgsql and postgres and I need some help with a part of
my function. In the function I loop through a multidemensional array
( [n][3] ), once, while inside the loop, I find the index I
Hi Everyone,
I have a table named concurrent_user which has a column time_stamp. The
column stores the timestamp for the latest entered record.
My query finds the difference of the timestamp from the current time, if
the value is larger than 5 minutes then the latest entered record in the
On 10/01/2008 12:30, Stefan Schwarzer wrote:
/usr/local/pgsql/bin/initdb -D --locale=en_US.UTF-8
/Users/schwarzer/Documents/data_postgres
Dunno if it'll make a difference, but I'd put the -D immediately
before the path to the data directory.
Ray.
I am testing postgres 8.3RC1 on some non production data and saw the
above security release.
I am loathe to patch our 8.0 and 8.1 production servers if 8.3 will be
out by month's end.
Is there any visibility of a production 8.3 release date?
---(end of
I am reading through HeadFirst SQL (an OReilly book) which uses
specific MySQLisms in its examples. I use postgres on our databases.
Some examples are easy to work around, some are not .
Is there a rosetta stone (table of commands in one and equivalents
inthe other) available?
In particular,
Hi All,
First, some background:
- We are using PostgreSQL 7.3.4, and am locked into this version. I would
upgrade if I could, but the decision is not mine.
- The table referred to below is 120+ million rows, and has a width of 27
columns (15 smallints, 5 integers, 4 dates, 1 integer[], 1 single
On 09.01.2008, at 13:51, Martin wrote:
I've been working with FrontBase a lot lately and I wouldn't say
anything about it qualifies as incredibly easy and reliable it
is not.
We had never ever any reliability issues with FrontBase as long as
didn't try to insert garbage. It really doesn't
CREATE INDEX
psql:sql/Pg-database.sql:825: ERROR: language plpgsql does not exist
HINT: You need to use createlang to load the language into the database.
psql:sql/Pg-database.sql:828: ERROR: current transaction is aborted,
commands ignored until end of transaction block
On Wed, Jan 09, 2008 at 03:02:53AM -0800, Robin-Vossen wrote:
So I thought lets add the language I miss.
doing:
createlang -d ledgersmb -U ledgersmb plpgsql
I keep getting:
createlang: language installation failed: ERROR: permission denied for
language c
You must run creatlang with a
On Jan 4, 2008 11:51 AM, Afewtips.com [EMAIL PROTECTED] wrote:
I do read mentions about dblink connections, but how to install it
looks unclear and complicated.
small clarification here. dblink is for connecting two postgresql
databases together. It is, IMO, neither unclear nor
Mark Walker escribió:
Ignoring the warnings not to use a beta product on a production database I
had been running 8.3beta1. When I saw that it had hit 8.3RC1 I decided to
upgrade and folowing the usual data compatibility within major versions I
did not do a pg_dump, in fact my last dump was
On Jan 10, 2008, at 6:01 AM, Simon Riggs wrote:
On Thu, 2008-01-10 at 11:18 +0100, Gábor Farkas wrote:
Simon Riggs wrote:
also, even if it is wrong, can an 'idle-in-transaction'
connection that
was opened today block the vacuuming of rows that were deleted
yesterday?
Yes, if the rows
/usr/local/pgsql/bin/initdb -D --locale=en_US.UTF-8 /Users/
schwarzer/Documents/data_postgres
Dunno if it'll make a difference, but I'd put the -D immediately
before the path to the data directory.
Thanks for the hint. But unfortunately same error message
On Jan 9, 2008, at 3:53 AM, R.A. wrote:
Hello,
I'm trying to create a composite type with an argument, to create
one field of this type like character varying(x), but I don't know
if this can be done with PostgreSQL. I want something like:
CREATE TYPE mytype AS (
tx character
Raymond O'Donnell [EMAIL PROTECTED] writes:
On 10/01/2008 12:30, Stefan Schwarzer wrote:
/usr/local/pgsql/bin/initdb -D --locale=en_US.UTF-8
/Users/schwarzer/Documents/data_postgres
Dunno if it'll make a difference, but I'd put the -D immediately
before the path to the data directory.
You may not have issues such that upping the # of users may be
a) running you out of postgres allocations (see your documentation for
details) ... increasing settings in the postgresql.conf file might help
(shared_buffers for instance, and shared_buffers )
or
b) not enough shared memory
On Jan 9, 2008, at 12:19 PM, leonardz wrote:
I am reading through HeadFirst SQL (an OReilly book) which uses
specific MySQLisms in its examples. I use postgres on our databases.
Some examples are easy to work around, some are not .
Is there a rosetta stone (table of commands in one and
On Jan 9, 2008, at 8:06 AM, Ewing, Chris wrote:
Hi Everyone,
I am trying to import data from a backed up PostgreSQL tablespace.
The server which the original data was on has been wiped.
1. I saved the tablespace onto a portable harddrive from the old
server. This contains the tablespace
/usr/local/pgsql/bin/initdb -D --locale=en_US.UTF-8
/Users/schwarzer/Documents/data_postgres
Dunno if it'll make a difference, but I'd put the -D immediately
before the path to the data directory.
Also, pay attention to the first few lines of initdb output ---
it will tell you what it thinks
On Thu, Jan 10, 2008 at 11:36:04AM +, Mark Walker wrote:
Ignoring the warnings not to use a beta product on a production database I
had been running 8.3beta1. When I saw that it had hit 8.3RC1 I decided to
upgrade and folowing the usual data compatibility within major versions I
did not do
I just upgraded my database server from 8.0.1 to 8.2.4
Most things went very well, but I have a couple of queries that really slowed
down with the new server.
On 8.0.1 the query took less then 3 seconds to complete. On 8.2.4 the same query
(I vacuumed the database before running the query) takes
On Jan 9, 2008 4:53 AM, R.A. [EMAIL PROTECTED] wrote:
Hello,
I'm trying to create a composite type with an argument, to create one field
of this type like character varying(x), but I don't know if this can be done
with PostgreSQL. I want something like:
CREATE TYPE mytype AS (
tx
On Jan 9, 2008 12:19 PM, leonardz [EMAIL PROTECTED] wrote:
I am reading through HeadFirst SQL (an OReilly book) which uses
specific MySQLisms in its examples. I use postgres on our databases.
Some examples are easy to work around, some are not .
Is there a rosetta stone (table of commands in
On Wed, Jan 09, 2008 at 06:14:10AM -0800, cdecarlo wrote:
Maybe, an example will help you understand what I want to do:
Let myArray be {{1,2,3},{4,5,6},{7,8,9}} and suppose the element I'm
looking for has, in it's first index, an even number. I would loop
through myArray looking at the first
On Jan 9, 2008 12:12 PM, leonardz [EMAIL PROTECTED] wrote:
I am testing postgres 8.3RC1 on some non production data and saw the
above security release.
I am loathe to patch our 8.0 and 8.1 production servers if 8.3 will be
out by month's end.
Is there any visibility of a production 8.3
Robin-Vossen wrote:
Subject: [GENERAL] After Installing a Program I get this
error: psql:sql/Pg-database.sql:825: ERROR: language
plpgsql does not exist
Define the PL/pgSQL language as described in
http://www.postgresql.org/docs/current/static/app-createlang.html
Yours,
Laurenz Albe
On Tue, Jan 08, 2008 at 08:21:40PM +0530, [EMAIL PROTECTED] wrote:
The query is something like :
DELETE from CONCURRENT_USER WHERE (now() - CONCURRENT_USER.TIME_STAMP)
?
Here the calculated value in '?' is not supported by the postgres as it
was set as a double.
In postgres subtracting
On 1/10/08, Sim Zacks [EMAIL PROTECTED] wrote:
I just upgraded my database server from 8.0.1 to 8.2.4
Most things went very well, but I have a couple of queries that really slowed
down with the new server.
On 8.0.1 the query took less then 3 seconds to complete. On 8.2.4 the same
query
(I
On Jan 8, 2008 8:51 AM, [EMAIL PROTECTED] wrote:
DELETE from CONCURRENT_USER WHERE (now() - CONCURRENT_USER.TIME_STAMP) ?
Here the calculated value in '?' is not supported by the postgres as it was
set as a double.
I tried to cast it to a timestamp by using Timestamp timestamp = new
2008/1/10, Sim Zacks [EMAIL PROTECTED]:
I just upgraded my database server from 8.0.1 to 8.2.4
Most things went very well, but I have a couple of queries that really slowed
down with the new server.
On 8.0.1 the query took less then 3 seconds to complete. On 8.2.4 the same
query
(I
On Jan 10, 2008 2:12 AM, Pavel Stehule [EMAIL PROTECTED] wrote:
On 10/01/2008, Matthew T. O'Connor [EMAIL PROTECTED] wrote:
Pavel Stehule wrote:
pgbench test - default configuration
Verze 7.3.15 7.4.13 8.0.8 8.1.4 8.2.beta1 8.3beta1
tps 311 340 334 398 423
Difference between timestamps will give you an interval. So the LHS of
is interval and hence the RHS should be an interval too. You should
not be converting the right hand side value to Timestamp. What is the
double value you are calculating? Is it in minutes, hours or days?
I am not a Java
Here are all of the data structures involved in this view.
Query Ran: select * from assemblycanbuild
CREATE OR REPLACE VIEW assemblycanbuild AS
SELECT assembliesbatchid,
CASE
WHEN min(
CASE
WHEN (stock::double precision - prioruse -
On Thu, Jan 10, 2008 at 08:58:07AM -0600, Erik Jones wrote:
Postgres doesn't support parameterized type declarations directly
(that I've ever heard of), but you could probably write a function
that uses EXECUTE to do this.
IIRC 8.3 will include the user-defined typmod which will allow such
On Jan 9, 2008 8:14 AM, cdecarlo [EMAIL PROTECTED] wrote:
On Jan 8, 11:35 am, [EMAIL PROTECTED] (Tom Lane) wrote:
The rest of your message suggests that what you want is not that at all,
but to set the other variable to an array that consists of one or
moreelements
from the original
On Wednesday 09 January 2008 3:02 am, Robin-Vossen wrote:
CREATE INDEX
psql:sql/Pg-database.sql:825: ERROR: language plpgsql does not exist
HINT: You need to use createlang to load the language into the database.
snip
So, I wonder what is the best and quickest way to fix this Flaw?
Thanks,
On Thu, Jan 10, 2008 at 01:50:42PM -0200, Clodoaldo wrote:
I posted about it
but the whole thread disappeared from the archives. It can still be
found here:
http://archives.free.net.ph/message/20080105.004509.22be255d.es.html
Huh? It's right there:
On Wed, Jan 09, 2008 at 06:19:40PM -0500, Brown, Richard wrote:
- We are using PostgreSQL 7.3.4, and am locked into this version. I would
upgrade if I could, but the decision is not mine.
I mean this sincerely and not snidely: get another job. 7.3.20 was the last
release in the 7.3 series.
2008/1/10, Martijn van Oosterhout [EMAIL PROTECTED]:
On Thu, Jan 10, 2008 at 01:50:42PM -0200, Clodoaldo wrote:
I posted about it
but the whole thread disappeared from the archives. It can still be
found here:
http://archives.free.net.ph/message/20080105.004509.22be255d.es.html
Huh?
On 10/01/2008 16:11, Clodoaldo wrote:
Where did you get that url? I can't find it here:
http://archives.postgresql.org/pgsql-general/2008-01/threads.php
It's on page 2 of the list.click Next, and then it's a little over
half-way down.
Ray.
Martijn van Oosterhout [EMAIL PROTECTED] writes:
On Thu, Jan 10, 2008 at 08:58:07AM -0600, Erik Jones wrote:
Postgres doesn't support parameterized type declarations directly
(that I've ever heard of), but you could probably write a function
that uses EXECUTE to do this.
IIRC 8.3 will
Clodoaldo escribió:
2008/1/10, Martijn van Oosterhout [EMAIL PROTECTED]:
http://archives.postgresql.org/pgsql-general/2008-01/msg00143.php
Where did you get that url? I can't find it here:
http://archives.postgresql.org/pgsql-general/2008-01/threads.php
Next page
--
Alvaro Herrera
Clodoaldo [EMAIL PROTECTED] writes:
2008/1/10, Martijn van Oosterhout [EMAIL PROTECTED]:
Huh? It's right there:
http://archives.postgresql.org/pgsql-general/2008-01/msg00143.php
Where did you get that url? I can't find it here:
http://archives.postgresql.org/pgsql-general/2008-01/threads.php
Merlin Moncure wrote:
On Jan 4, 2008 11:51 AM, Afewtips.com [EMAIL PROTECTED] wrote:
I do read mentions about dblink connections, but how to install it
looks unclear and complicated.
small clarification here. dblink is for connecting two postgresql
databases together. It is, IMO, neither
On Jan 10, 2008 9:50 AM, Clodoaldo [EMAIL PROTECTED] wrote:
2008/1/10, Sim Zacks [EMAIL PROTECTED]:
I just upgraded my database server from 8.0.1 to 8.2.4
Most things went very well, but I have a couple of queries that really
slowed down with the new server.
On 8.0.1 the query took less
Mark Walker wrote:
What can I do, a dump is impossible because I cannot re-install the
version that the database was last used with (it should have been first
initialised on 8.2, as I went to the beta to experiment with enum having
recently returned from MySQL).
Any help appreciated,
folks
the follow queries work in postgres 8.2 but
in 8.3beta don't work
SELECT c.* FROM c WHERE c.numero LIKE '1%';
i think automatic conversion of numeber to text is
the problem , in 8.3beta don't work
numero field is integer type
any ideas?
best regards
mdc
ps:PostgreSQL
On Jan 10, 2008 9:50 AM, Clodoaldo [EMAIL PROTECTED] wrote:
I have seen performance degradation at every new version since 7.3.
But now 8.3 is a complete disaster. It could be that my most expensive
query is just a corner case, but I don't believe it. I posted about it
but the whole thread
Stefan Schwarzer [EMAIL PROTECTED] writes:
Also, pay attention to the first few lines of initdb output ---
it will tell you what it thinks it's supposed to use for locale.
It tells me the following:
The files belonging to this database system will be owned by user
schwarzer.
This user
Hello,
it isn't bug. You have to cast to string before.
http://www.postgresql.org/docs/8.3/static/release-8-3.html
E.1.2.1. General
Regards
Pavel Stehule
On 10/01/2008, marcelo Cortez [EMAIL PROTECTED] wrote:
folks
the follow queries work in postgres 8.2 but
in 8.3beta don't work
Pavel
--- Pavel Stehule [EMAIL PROTECTED] escribió:
Hello,
it isn't bug. You have to cast to string before.
http://www.postgresql.org/docs/8.3/static/release-8-3.html
E.1.2.1. General
Yes you are right, but my queries was generated for
one mapper ,explicit cast is not an option ( not
On Jan 10, 2008 11:12 AM, Clodoaldo [EMAIL PROTECTED] wrote:
2008/1/10, Scott Marlowe [EMAIL PROTECTED]:
I have seen performance degradation at every new version since 7.3.
Then your experience has been exactly the opposite of mine.
I suspect some developers here make a living from
I meant I did Vacuum Analyze.
In any case, Aside from the vacuum analyze, I also tested it right after a
database restore, so there should be no need for any maintenance features.
Sim
Isak Hansen wrote:
On 1/10/08, Sim Zacks [EMAIL PROTECTED] wrote:
I just upgraded my database server from
Most of the queries that I have tested work on 8.2.4 at least as fast as on
8.0.1.
This one has really thrown me for a loop.
Sim
Could you try 8.3 and see what happens? Keep the emails in case this
thread mysteriously disappears.
Please stop the histrionics. If your new query is slower,
On Jan 10, 2008, at 10:47 AM, marcelo Cortez wrote:
folks
the follow queries work in postgres 8.2 but
in 8.3beta don't work
SELECT c.* FROM c WHERE c.numero LIKE '1%';
i think automatic conversion of numeber to text is
the problem , in 8.3beta don't work
numero field is integer type
marcelo Cortez escribió:
folks
the follow queries work in postgres 8.2 but
in 8.3beta don't work
SELECT c.* FROM c WHERE c.numero LIKE '1%';
i think automatic conversion of numeber to text is
the problem , in 8.3beta don't work
numero field is integer type
This is
2008/1/10, Scott Marlowe [EMAIL PROTECTED]:
On Jan 10, 2008 9:50 AM, Clodoaldo [EMAIL PROTECTED] wrote:
2008/1/10, Sim Zacks [EMAIL PROTECTED]:
I just upgraded my database server from 8.0.1 to 8.2.4
Most things went very well, but I have a couple of queries that really
slowed down
marcelo Cortez escribió:
Pavel
--- Pavel Stehule [EMAIL PROTECTED] escribió:
Hello,
it isn't bug. You have to cast to string before.
http://www.postgresql.org/docs/8.3/static/release-8-3.html
E.1.2.1. General
Yes you are right, but my queries was generated for
one
I don't an answer to your question, but an obvious difference is that
the slow query contains many more loops. (this may already have been
noted, I didn't see it posted however).
(showing just the loops with more than one loop)
- Index Scan using assemblies_pkey on assemblies a
Hi List;
I'm researching a db and I want to find samples of some of the data. I know
based on the documentation for the proposed new schema that the db I have
access to (the old schema) probably has a column in one or more of the user
tables called 'region'.
I'm looking for a way to query
Alvaro
--- Alvaro Herrera [EMAIL PROTECTED]
escribió:
marcelo Cortez escribió:
Pavel
--- Pavel Stehule [EMAIL PROTECTED]
escribió:
Hello,
it isn't bug. You have to cast to string before.
http://www.postgresql.org/docs/8.3/static/release-8-3.html
E.1.2.1.
On Thu, Jan 10, 2008 at 11:08:16AM -0500, Andrew Sullivan wrote:
I mean this sincerely and not snidely: get another job. 7.3.20 was the last
Err, 7.3.21, I meant, of course. Sorry.
A
---(end of broadcast)---
TIP 4: Have you searched our list
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 10 Jan 2008 10:38:16 -0700
Kevin Kempter [EMAIL PROTECTED] wrote:
Hi List;
I'm researching a db and I want to find samples of some of the data.
I know based on the documentation for the proposed new schema that
the db I have access to
On 1/10/08, Sim Zacks [EMAIL PROTECTED] wrote:
I meant I did Vacuum Analyze.
In any case, Aside from the vacuum analyze, I also tested it right after a
database restore, so there should be no need for any maintenance features.
The stats didn't look too far off, no.
Perhaps a suboptimal plan
2008/1/10, Scott Marlowe [EMAIL PROTECTED]:
On Jan 10, 2008 9:50 AM, Clodoaldo [EMAIL PROTECTED] wrote:
I have seen performance degradation at every new version since 7.3.
But now 8.3 is a complete disaster. It could be that my most expensive
query is just a corner case, but I don't
Scott Marlowe [EMAIL PROTECTED] writes:
OK, I was looking at the previous thread that you thought had
disappeared, and with the explain analyze output from 8.3 I noticed
something odd.
For 8.2 you had something like this:
QUERY PLAN
Clodoaldo escribió:
If you read that thread you will notice my experience with
xlog_seg_size of 1GB which makes the time goes down to 1,300 sec,
still much more than 8.2.
Do tell, what's your wal_buffers setting? Have you tried increasing
that?
--
Alvaro Herrera
On Thu, 10 Jan 2008, Alvaro Herrera wrote:
Do tell, what's your wal_buffers setting? Have you tried increasing
that?
Original post here suggested wal_buffers=512kb in 8.2 and 1024kb in the
8.3 config. Seemed plenty big for this scale of server.
--
* Greg Smith [EMAIL PROTECTED]
On Jan 10, 2008 10:50 AM, Sim Zacks [EMAIL PROTECTED] wrote:
I meant I did Vacuum Analyze.
In any case, Aside from the vacuum analyze, I also tested it right after a
database restore, so there should be no need for any maintenance features.
FYI, a restore does NOT restore the stats, nor does
Chris Browne wrote:
[EMAIL PROTECTED] (Zoltan Boszormenyi) writes:
SELECT COUNT(*)
[Waving hands for a moment]
Would what Chris describes below be a good candidate for
a pgfoundry project that has functions that'll create the
triggers for you? (yeah, I might be volunteering, but would
It does contain a lot more loops, but it is the exact same query, so I don't
understand why it would use that kind of plan
sim
Bricklen Anderson wrote:
I don't an answer to your question, but an obvious difference is that
the slow query contains many more loops. (this may already have been
Perhaps a suboptimal plan is picked due to configuration issues, e.g.
memory constraints? Could you post your postgresql.conf as well?
Below is the postgresql.conf file for 8.2.4. The server has 2 GB of RAM and it
was not maxed out when I ran the query.
As I mentioned, I tried running both
On Jan 10, 2008 12:33 PM, Sim Zacks [EMAIL PROTECTED] wrote:
Perhaps a suboptimal plan is picked due to configuration issues, e.g.
memory constraints? Could you post your postgresql.conf as well?
Below is the postgresql.conf file for 8.2.4. The server has 2 GB of RAM and
it was not maxed
1 - 100 of 119 matches
Mail list logo