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 to be
that is because 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 Olive
18.php
--
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
using version >= 8.3. Just do:
BEGIN;
TRUNCATE TABLE foo;
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 d
].
[1] http://wiki.postgresql.org/wiki/Slow_Counting
--
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
own limitation; but even if it would 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-
re.
>
And make sure 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.postgr
eric))
Out of curiosity, why does foreign key have different datatype of its primary
key?
--
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
quot;
$ psql -U postgres -c "$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 recommen
too risky to
do 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
_field, then you 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.po
s done); did you try 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
14 matches
Mail list logo
