Tag Info

New answers tagged

3

You need to replace the $1 with the column name from the select: The query: select GetAppDate(appt.startdatetime) from tablename appt passes the column startdatetime to the function, so your select was almost there, but no quite - you forgot to replace the $1 and you incorrectly replaced the call to the function' variable with the column name: select ...


3

Actually, I want to give a comment about your question. I can't to do that because I have low reputation here. So, I decided to answer whether it fits with your question or not. Let's I start. Would you like determine "query is inserted" first? I have an assumption about your "query is inserted". "Query is inserted" is every query is inserted or affected ...


4

The datcollate column of pg_database stores LC_COLLATE for this database An other page of the documentation about collations says: The collation feature allows specifying the sort order and character classification behavior of data per-column, or even per-operation. This alleviates the restriction that the LC_COLLATE and LC_CTYPE settings of ...


1

The formula that probably explains your case is (as documented in The Autovacuum Daemon): ...if the number of tuples obsoleted since the last VACUUM exceeds the "vacuum threshold", the table is vacuumed. The vacuum threshold is defined as vacuum threshold = vacuum base threshold + vacuum scale factor * number of tuples where the vacuum ...


2

vacuum: Clears out deleted records from disk Not exactly. VACUUM marks rows that aren't visible to any active transaction any more as dead (and ready for re-use). It does not shrink the physical file size that represents the table, except for completely dead / empty pages at the physical end. The manual explains everything and probably better than I ...



Top 50 recent answers are included