| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Tom DalPozzo <t(dot)dalpozzo(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: WAL being written during SELECT * query |
| Date: | 2017-04-04 17:05:47 |
| Message-ID: | 9df2005f-1aa9-c70a-def7-a29c88f019f2@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 04/04/17 16:46, Tom DalPozzo wrote:
> Hi,
> I have a very big table (10GB).
> I noticed that many WAL segments are being written when elaborating read
> only transactions like this:
> select * from dati25600000000 where id >43000000 limit 1000000;
> I don't understand why are there WAL writings during read only transactions.
As far as I know (and I could be wrong), WAL segments reflect activity
in the entire cluster, not just one table - so perhaps there is write
activity happening in other tables, or in other databases.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2017-04-04 17:18:04 | Re: WAL being written during SELECT * query |
| Previous Message | Armand Pirvu (home) | 2017-04-04 16:06:58 | Re: store key name pattern search |