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
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
-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
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
_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
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
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
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
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
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-
].
[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
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
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
14 matches
Mail list logo
