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
-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 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
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
--
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
;
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
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
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
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
$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
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
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
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
13 matches
Mail list logo