Reputation
7,773
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 42
Newest
 Revival
Impact
~352k people reached

2h
comment Column Datatype Conversion Question
So you want to remove the time part? Anyway, you should look at the to_date() function.
2h
comment how to use index to speed up sorting in postgres
At a first glance, the ORDER BY in the subquery is totally useless. Furthermore, the linked plan cannot be a result of the posted query - there is no mention of metadata, for example.
3h
revised how to use index to speed up sorting in postgres
formatting
15h
comment Install PostGIS v2 for PostgreSQL v9.2
The links are subject to link rot, please consider adding the important substeps from them to your answer. Thanks in advance!
2d
comment Login Roles not showing at previleges tab
Have you tried to reconnect?
Apr
24
comment How to catch code of error which occured inside plv8 function?
Writing to Andrew about this could be possibly a good idea, you will find his email address at pgxn.org/user/andrew
Apr
24
comment Should I use array in column or not?
This is simply a bad idea™. Normalize your data. And I'd suggest never using a floating point type to store monetary data.
Apr
24
comment How to catch code of error which occured inside plv8 function?
It's not clear if you do some error handling in your function and what exactly 'pg client' is.
Apr
24
comment PostgreSQL: Best way to INSERT for vertical search engine
And what's a vertical search engine?
Apr
23
comment Is it possible for a client to kill a long-running Postgres query?
It is possible to send a ctrl+c or similar from the client that runs the query. Otherwise, it is only possible to kill it with pg_terminate_backend(), that needs superuser rights. Or it can be sent a SIGTERM from the OS, if you have access there.
Apr
23
reviewed Approve Join two tables and return data and count in a single query
Apr
23
reviewed Leave Closed Unable to start SQL Server Browser service in Sql server 2005
Apr
23
reviewed Close mdf files too big in SQL Server 2005
Apr
23
reviewed Reviewed Write a query to create skill table. Please note that the field description can be NULL and the default value is NULL
Apr
23
reviewed Reviewed Speed up procedure
Apr
23
comment Speed up procedure
Could you maybe post the table definitions and the execution plan, too?
Apr
23
reviewed Approve plsql tag wiki
Apr
23
reviewed Approve plsql tag wiki excerpt
Apr
23
comment PostgreSQL: changing password for a user is not working
This is the default.
Apr
23
comment What to do with WAL files for Postgres Slave reset
I think the cleanest and safest way is just to rebuild the slave completely. pg_start_backup() is not supposed to lock the DB, except when you pass fast = TRUE to it - this latter will cause a slowdown of any concurrently executing queries. See postgresql.org/docs/9.4/static/…