12,570 reputation
12048
bio website
location Munich
age
visits member for 3 years, 6 months
seen 31 mins ago

Apr
22
comment What happens when we call pg_dump while users are still using the system?
Short of buying faster harddisks - no. Note that pg_dump creates a "snapshot". Usually that is not considered a backup. Using WAL archiving you can create "real" backups that also allow restoring the data to a specific point in time. See the manual for details: postgresql.org/docs/current/static/continuous-archiving.html
Apr
22
comment What happens when we call pg_dump while users are still using the system?
pg_dump takes a consistent snapshot from the database so it will not cause any inconsistencies.
Apr
22
reviewed Leave Closed Do I need to stop the service to back up the database?
Apr
22
revised PostgreSQL 9.3 on Ubuntu Server 12.04 v.s. MS SQL Server 2008 R2 on Windows 7 Ultima
deleted 3 characters in body
Apr
21
comment How to get back sql table data?
Restore your backup
Apr
21
revised Connecting to a remote Postgres 9.1 DB
added 11 characters in body
Apr
19
comment Postgresql JDBC Table Valued Parameters
You insert into it and then you select from it. There is nothing special about using a temp table (apart from the fact that the rows automatically go away). Any decent JDBC tutorial will have examples for inserting and reading from a table.
Apr
19
comment Postgresql JDBC Table Valued Parameters
Why don't you use a temporary table?
Apr
19
comment Postgresql JDBC Table Valued Parameters
Cross posted: stackoverflow.com/questions/23008966
Apr
19
comment Oracle 12C, cannot drop NOT NULL constraint on a DEFAULT ON NULL column
Any triggers on the table?
Apr
18
awarded  Deputy
Apr
18
reviewed Approve suggested edit on MySQL login after install
Apr
17
comment DISTINCT not using an index
explain plan for select ...; select * from table(dbms_xplan.display);
Apr
17
comment DISTINCT not using an index
Well if the column is nullable the index cannot be used as tuples consisting completely of null values won't make it into the index. You can trick Oracle to index them nonetheless using an index defined as (column4, 1). Btw: why don't you just copy and paste the text result of an explain. That is usually much easier to read than an image or some other obfuscated output.
Apr
17
comment DISTINCT not using an index
Is the column nullable? And what does the execution plan say?
Apr
17
revised SQL Server Permission
edited tags
Apr
16
revised Index is not used with same Query on two Servers
edited tags
Apr
16
comment ORA-30009: Not enough memory for CONNECT BY operation
None of those tips will reduce the memory required by a connect by query.
Apr
16
comment ORA-30009: Not enough memory for CONNECT BY operation
Please show us the query and the execution plan.
Apr
16
comment Can comments in stored procedures cause problems
I have seen situations where such comments caused trouble (it's been a while, can't recall the exact circumstances). After using block comments /* ... */ instead of line comment things were OK.