11,153 reputation
11842
bio website
location Munich
age
visits member for 3 years, 2 months
seen 3 mins ago

Jul
5
comment Detailed optimal column order with large text and bytea
long text (or varchar) or bytea values are not stored inside the actual row.
Jul
5
comment Full table scan even after adding index
Please supply the execution plan and the full definition of the tables and indexes. Also which DBMS are you using?
Jul
5
comment Time series and gap filling
Not sure what you mean with "time series", but did you look into Postgres range data types? michael.otacoo.com/postgresql-2/…
Jul
4
comment PostgreSQL : inconsistent result when using WHERE clause on VIEW
An order by in a derived table (aka sub-select) doesn't make sense.
Jul
4
comment MS SQL - export tables to format compatible with PostgreSQL
I agree with Craig: you need to adjust your existing DDL scripts to Postgres syntax, create the tables, export from SQL Server as text (csv), then import. You might also want to try sqlserver2pg. I never used it, so I don't know if it works well: github.com/dalibo/sqlserver2pgsql
Jul
3
comment What is best strategy for backup on streaming replication(hot standby) environment
barman claims to be able to take a backup on the slave: docs.pgbarman.org/#concurrent_backup_and_backup_from_a_standby
Jul
3
comment How to insert into view through GUI in pgAdmin?
Did you check the DbExplorer's "Data" tab? You can even start the DbExplorer as a stand-alone window. So the users won't see a SQL editor or something similar. Only the list of tables/views. Click on the view, click on "Data", done.
Jul
3
comment Find status of shutdown immediate
And why can't you do that on Windows?
Jul
2
comment Postgres : Executing SELECT within a transaction does not return most recent rows
No, but the ids you are looking for have to be stored in some table, and you can have a FK to that.
Jul
2
comment Postgres : Executing SELECT within a transaction does not return most recent rows
I don't understand why you have the trigger in the first place. Looks like you are trying to implement a foreign key check there, so why not just use a foreign key constraint?
Jul
2
comment Postgres multidisk master replicating to single disk slave
Can't you just create symbolic links that on the slave that match the mount points of the tablespaces on the master?
Jul
2
comment How to insert into view through GUI in pgAdmin?
sql-workbench.net also allows editing a result set based on a view (of course only if the view itself is updateable as well)
Jul
1
comment Postgres table growing on massive updates
What is your Postgres version? What are your autovacuum settings? vacuum full is not such a good idea especially if you are using and older Postgres version.
Jul
1
comment PostgreSQL Automatic Failover (Trigger File Creation)?
postgresql.org/docs/current/static/app-pg-isready.html You might also want to have a look at repmgr which also supports automatic failover
Jul
1
comment Does mariadb provide a Type 2 driver?
Type 2 drivers are a relic from the old ages where no native (i.e Type 4) drivers were available. There is absolutely no reason to use one in 2014 - not even for "learning purposes". Btw: the DB doesn't care whether a JDBC driver is Type 2, Type 3 or Type 4. The driver always needs talks to the database in the same way. The difference is the code that runs on the client not how the communication is done.
Jul
1
comment How to grant drop table/function privileges to a role in PostgreSQL?
You might be interested in this: stackoverflow.com/questions/24410198/…
Jul
1
comment getting “table is full” error even if the table size is much smaller than tablespace
"a varchar(100) variable will reserve all the space like you have 100 characters in all rows of the column" - is that a special "feature" of NDBCLUSTER? Because InnoDB (or MyISAM) don't do that. It would be true for char(100) though.
Jul
1
comment How do I stop views (large data sets) from freezing my database
What exactly do you mean with "commands to refresh views"? A view doesn't need a "refresh" the data in there is always "up-to-date".
Jun
30
comment Is select * still a big no-no on SQL Server 2012?
I consider select * bad coding style in any DBMS not just SQL Server.
Jun
30
comment JDBC , make connection static to improve performance
You should use a connection pool (and btw: JDBC is not "slow")