Daniele Varrazzo <[EMAIL PROTECTED]> wrote:
>
>> select count(*) from foo
>> where foo.account_id in (
>> select id from accounts where system = 'abc');
>
>> Total runtime: 13412.226 ms
>
> Out of curiosity, how does it do with the logically equivalent?:
>
> select count(
>>> Daniele Varrazzo <[EMAIL PROTECTED]> wrote:
> select count(*) from foo
> where foo.account_id in (
> select id from accounts where system = 'abc');
> Total runtime: 13412.226 ms
Out of curiosity, how does it do with the logically equivalent?:
select count(*) from f
Good idea. Note that Postgres is already doing this to some extent
with TOAST - read
http://www.postgresql.org/docs/8.3/interactive/storage-toast.html -
unfortunately, there doesn't seem to be an option to always move
particular columns out to TOAST. Your idea will produce an even
smaller ta
Antonio Perez wrote:
[wonders why his online backup / recovery test didn't work]
> 1.Se crea una instancia de postgreSQL
>
> 2.Se crea un directorio $PGDATA/walback donde se almacenararn los wal
> antiguos
>
> 3.Se exporta una variable $PGDATA2 que es la ubicacion del respaldo del
