"Arnold, Sandra" wrote:
> Coming from the Oracle world we were able to have a different
> default tablespace for each user or for a group of users. Can you
> set the default tablespace to be different for a group
> users/schemas in PostgreSQL?
ALTER ROLE xxx SET default_tablespace = yyy;
ht
Coming from the Oracle world we were able to have a different default
tablespace for each user or for a group of users. Can you set the default
tablespace to be different for a group users/schemas in PostgreSQL? Or, do you
have to set the default tablespace at the database level? If you can s
Hello !
in order to reduce disk space used by postgresql's archived logs I use the
following command for the parameter archive_command :
archive_command = 'gzip -c %p >/u10/pgmi/postgresql/archive/%f.gz'
I have configured a standby database with the contrib module and pg_stanby.
My question is
Andy,Why not first try the downloads page on PostgreSQL itself: http://www.postgresql.org/download/; these builds have most of the dependencies built in, and are a good starting point.Many of us, ultimately, do our own builds to serve specific purposes, but there's no reason to start your explorati
Here is my UPDATE query and EXPLAIN ANALYZE output:
UPDATE query:
UPDATE MYUPDATETABLE SET ABOOLEANCOLUMN = TRUE WHERE COMPANYID = 999 AND
EMAIL1 = 'someem...@somedomain.com'
EXPLAIN ANALYZE output:
Bitmap Heap Scan on myupdatetable (cost=190.89..16107.70 rows=45
width=1826) (actual time=31.150.
Hi,
Antonio You have to remember to put ORDER BY clause because LIMIT
returns random rows if You would like to return let's say 100 rows
starting from row #250 the query would be sth like this:
SELECT emp_id, name, surname, dept FROM empleyees LIMIT 100 OFFSET 250
ORDER BY emp_id
2011/2/4 Guillau
