On 05/16/2015 10:44 PM, Maks Materkov wrote:
I have a database, table "users", with column "profile_id", and the
following query:
EXPLAIN ANALYZE SELECT * FROM users_user WHERE profile_id IN (...50 ids...);
Result:
Index Scan using users_user_83a0eb3f on users_user (cost=0.50..292.22
rows=
On 03/18/2015 09:20 AM, adityagis wrote:
Dear Users,
I have lots of data in my DB. I need to do archeiving and purging of my
data.
Can anyone please help me with step by step riles?
Thanks in Advance.
Aditya Kumar
--
View this message in context:
http://postgresql.nabble.com/Archeiving-an
On 03/04/2015 12:11 AM, David G Johnston wrote:
In short - since the planner determines exclusion constraints and the
executor, which strictly follows the planner in the query execution process,
would be the one to determine what the value of your date is - there is no
way for a single query to
Howdy,
I spent a majority of today playing around with pg_partman (awesome tool
btw!). I am mainly using the time-static method with an interval of one
month.
I wanted to see what performance improvements I could get with some
common queries that are used by our analytics team. A lot of these
On 02/22/2015 01:53 PM, Scott Marlowe wrote:>
> I'd run a debian based distro (Ubuntu or Debian work well) and use the
> pg_* commands to create the clusters the same way. Gives you the
> maximum separation for clients.
>
> pg_createcluster
>
> Usage: /usr/bin/pg_createcluster [options]
> [-- ]
On 02/21/2015 05:25 PM, David Steele wrote:
On 2/21/15 6:08 PM, Adrian Klaver wrote:
Currently the built in replication solutions work at the cluster level,
not at the database level. There are third party tools, Slony and
Bucardo come to mind, that can work at a more focused level.
Again, it
Howdy,
I am looking for advice on migrating to postgres from another database
system.
Without going into too much detail, my company offers a software
solution which we self host ourselves in our data center. We have gotten
a green light from management to start using postgres as a free and
