STABLE? Could you show us the
EXPLAIN ANALYZE of query and function?
--
Euler Taveira de Oliveira
http://www.timbira.com/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
need an index on it. Maybe you could try ip4r [1].
[1] http://pgfoundry.org/projects/ip4r/
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
such a change when the server is running. You need to stop the database and
make the change. Also, you can setup the xlog to a different location at
initdb time.
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org
$myq sleep 60 psql -U postgres -c $myq
sum
---
178992891
(1 row)
sum
---
178996065
(1 row)
$ bc -q
scale=3
(178996065-178992891)/60
52.900
Depending on your workload pattern, it's recommended to increase the sleep time.
--
Euler Taveira de Oliveira
http
are not using the indexes. Do you have
autovacuum turn on? Do you recently analyze your tables?
Merge Cond: (statsdata8_21_2009.pollid =
((polleddata.id)::numeric))
Out of curiosity, why does foreign key have different datatype of its primary
key?
--
Euler Taveira de Oliveira
archive mode is turned off. Otherwise, you can't use the WAL
bypass facility.
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
be possible I don't think it
would be a good idea. Why on Earth would I search using a big field?
What kind of content are you trying to index?
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes
;
COPY foo FROM ...;
COMMIT;
PostgreSQL will skip WAL writes and just fsync() the table at the end of the
command.
Also, take a look at [1].
[1] http://www.postgresql.org/docs/current/interactive/populate.html
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-performance
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
atoi() is so fragile.
So where we're at now is that the maximum database pgbench can create is
a scale of 21474.
That's because 21475 * 100,000 INT_MAX. We must provide an alternative to
atoi() that deals with 64-bit integers.
--
Euler Taveira de Oliveira
http://www.timbira.com
Em 10-01-2011 05:25, Greg Smith escreveu:
Euler Taveira de Oliveira wrote:
Em 07-01-2011 22:59, Greg Smith escreveu:
setrandom: invalid maximum number -2147467296
It is failing at atoi() circa pgbench.c:1036. But it just the first
one. There are some variables and constants that need
-config-wal.html#GUC-WAL-KEEP-SEGMENTS
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Em 24-03-2011 11:40, Uwe Bartels escreveu:
Or is there a dynamic way to put $PGDATA/base/pgsql_tmp into RAM without
blocking it completely like a ram disk?
Create a tablespace in a ram disk and set temp_tablespaces.
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql
13 matches
Mail list logo