Re: [DOCS] alter query not work

2016-09-16 Thread Aleksey Tsalolikhin
Try ALTER USER rather than ALETR USER "ALTER" means change. If you need further help, try the pgsql-novice mailing list, https://www.postgresql.org/list/pgsql-novice/ as this list is for discussion of issues related to maintaining the Postgres documentation. Best, Aleksey On Mon, Sep 12, 2016 a

[DOCS] what is a "working set" ?

2012-04-23 Thread Aleksey Tsalolikhin
Hi. I'm trying to find a definition of "working set", it seems important for performance tuning, but I cannot find a PostgreSQL document defining it. Yours, Aleksey -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/ma

Re: [DOCS] Addition to TOAST documentation in 8.4 comprehensive manual

2011-01-21 Thread Aleksey Tsalolikhin
Dear Robert, I understand, thank you. I didn't know how to get the parent table name, that is to say, didn't know what SQL query to run, not being familiar with postgres's internal catalog. I might just drop this as a little how-to into the Wiki for other PostgreSQL newbies like myself. I

Re: [DOCS] Addition to TOAST documentation in 8.4 comprehensive manual

2011-01-19 Thread Aleksey Tsalolikhin
n Sat, Jan 8, 2011 at 7:58 AM, Aleksey Tsalolikhin wrote: > On Sat, Jan 8, 2011 at 3:16 AM, Robert Haas wrote: >> On Wed, Dec 22, 2010 at 9:05 PM, Aleksey Tsalolikhin >> wrote: >>> I'd like to add the following to my proposed documentation tidbit, please: >>&g

Re: [DOCS] Addition to TOAST documentation in 8.4 comprehensive manual

2011-01-08 Thread Aleksey Tsalolikhin
On Sat, Jan 8, 2011 at 3:16 AM, Robert Haas wrote: > On Wed, Dec 22, 2010 at 9:05 PM, Aleksey Tsalolikhin > wrote: >> I'd like to add the following to my proposed documentation tidbit, please: >> > > I think this might be a good thing to mention somewhere, but c

Re: [DOCS] Addition to TOAST documentation in 8.4 comprehensive manual

2010-12-22 Thread Aleksey Tsalolikhin
I'd like to add the following to my proposed documentation tidbit, please: The more offical/strict way, that does not rely on the implementation artifact that TOAST numeric ID is embedded in the TOAST symbolic name, is: select oid::regclass from pg_class where reltoastrelid='pg_toast_12513885'

[DOCS] Addition to TOAST documentation in 8.4 comprehensive manual

2010-12-22 Thread Aleksey Tsalolikhin
Hello, I'd like to suggest a small addition to the TOAST overview in the 8.4 comprehensive manual, Chapter 53.2 TOAST. This is my first doc patch for postgres, so if this is not appropriate, please advise. I spent almost an hour trying to figure out how to go from the TOAST table id to the o