Reputation
16,840
Next tag badge:
453/400 score
79/80 answers
Badges
4 43 87
Newest
 Nice Answer
Impact
~1.5m people reached

Jan
26
revised What's the difference between a CTE and a Temp Table?
This needs to be an answer, not a direct response to another answer (which would need to be a comment on his answer). I've adjusted accoringly.
Jan
25
revised Is inserting multiple queries takes same time as that of single query?
edited tags; edited tags
Jan
25
comment Take advantage of monotonic columns in PostreSQL
@giomasce it doesn't necessarily mean that - a functional index could cast/round. eg if your fp values are between 0 and 1, and your integers between 0 and 1000, multiply by 1000 and round for the index. Obviously your query will have to do the same conversion as the index for it to be used.
Jan
25
comment Take advantage of monotonic columns in PostreSQL
@a_horse_with_no_name thanks. Those 3 blocks touched are all the rows with foo<=1100. If that foo condition doesn't restrict the matched rows much then most of the index is scanned even when the query ultimately returns the same number of rows (113).
Jan
25
comment Take advantage of monotonic columns in PostreSQL
@a_horse_with_no_name does the plan show what percentage of the index is touched, or if not is there any way of getting that statistic?
Jan
24
comment how to check whether Oracle database is accessed or not?
What version of Oracle do you have?
Jan
24
revised how to check whether Oracle database is accessed or not?
removed tagline
Jan
24
comment how to check whether Oracle database is accessed or not?
Note that you need Diagnostic Pack to even access most of those views.
Jan
24
revised how to check whether Oracle database is accessed or not?
added 685 characters in body
Jan
24
comment Take advantage of monotonic columns in PostreSQL
you might be interested to know that ypercube suggested a simpler version of this answer in The Heap
Jan
24
comment Take advantage of monotonic columns in PostreSQL
I noticed that too late :)
Jan
24
revised Working of indexes in PostgreSQL
removed 'thanks' - votes and accepted answer are enough and this reduced noise for others
Jan
24
comment Take advantage of monotonic columns in PostreSQL
Also, you may like to read all the answers on this related question
Jan
24
comment Take advantage of monotonic columns in PostreSQL
hmmm, I should probably read the whole question before answering. Why would you want to avoid the workaround? The issue here is that you know your data better than postgres knows it (how could pg be sure the two columns are going to be monotonically related tomorrow even if it can see that they are today?)
Jan
24
revised Take advantage of monotonic columns in PostreSQL
added 321 characters in body
Jan
24
answered Take advantage of monotonic columns in PostreSQL
Jan
23
accepted Does postgres efficiently re-use space from deleted rows?
Jan
23
comment Is there are a way to restore System schema to it's original state?
Backups aren't for getting back to an empty database, use DBCA as you say or DROP/CREATE DATABASE.
Jan
23
comment Is there are a way to restore System schema to it's original state?
The question remains why those tables were imported in the system schema (or do you mean the system tablespace?). What were they doing in the system schema in the first place before the export?
Jan
22
comment Is there are a way to restore System schema to it's original state?
Do you mean you want to go back to an empty database? You can drop and create databases. What are these 'useless' tables (please give an example), I'm concerned they may not be as useless as you think.