#database-performance

[sevennet-blog]

Solution: Bad performance for a large join query in PostgreSQL 8.4.4, despite enough memory to cache entirely #programming #it #computers

Solution: Bad performance for a large join query in PostgreSQL 8.4.4, despite enough memory to cache entirely #programming #it #computers

Bad performance for a large join query in PostgreSQL 8.4.4, despite enough memory to cache entirely

Question

How can I make the query described in this post faster, in particular by making PostgreSQL using the available RAM? – Note that I have tried to configure effective_cache_size and shared_buffers appropriately. See below.

Background

I have to regularly join a ~260 million row table…

View On WordPress

[goodanswerbiz]

How-to: SQL Server Express for Production Databases? #computers #fix #it

How-to: SQL Server Express for Production Databases? #computers #fix #it

SQL Server Express for Production Databases?

We are about to roll out a dual web/internal transactional application where each client has their own database. Each database is very small – under 50MB each, so we were wondering if it would make sense to use SQL Express 2008 instead of the full SQL Server.

This seems to have the advantages of distributing disk I/O across servers while saving…

View On WordPress

[goodanswerbiz]

Fixed: Do I need to REINDEX and VACUUM a table after deleting lots of rows? #it #dev #computers

Fixed: Do I need to REINDEX and VACUUM a table after deleting lots of rows? #it #dev #computers

Do I need to REINDEX and VACUUM a table after deleting lots of rows?

I am running a PostgreSQL database that has several tables which store logging information. This information is for reporting purposes only and gets dumped to a file and deleted from the database if older than 30 days.

There can be millions of rows deleted, and we have been running a REINDEX each time after deletion.

Is this…

View On WordPress

[sevennet-blog]

Solution: SQL Server Express for Production Databases? #fix #solution #it

Solution: SQL Server Express for Production Databases? #fix #solution #it

SQL Server Express for Production Databases?

We are about to roll out a dual web/internal transactional application where each client has their own database. Each database is very small – under 50MB each, so we were wondering if it would make sense to use SQL Express 2008 instead of the full SQL Server.

This seems to have the advantages of distributing disk I/O across servers while saving…

View On WordPress

[goodanswerbiz]

Resolved: postgreSQL vs Cassandra vs MongoDB vs Voldemort? #it #development #answer

Resolved: postgreSQL vs Cassandra vs MongoDB vs Voldemort? #it #development #answer

postgreSQL vs Cassandra vs MongoDB vs Voldemort? Which database to decide upon? Any comparisions?

Existing: postgresql

Issues

Not easily scalable horizontal. Needs sharding etc

Clustering does not solve the data growth problem

Looking for: Any database that is easily horizontally scalable

Cassandra (Twitter uses that?)

MongoDB (rapidly gaining popularity)

Voldemort

Other?

Why?

Data growing with…

View On WordPress

[sevennet-blog]

How to: Do I need to REINDEX and VACUUM a table after deleting lots of rows? #dev #development #computers

How to: Do I need to REINDEX and VACUUM a table after deleting lots of rows? #dev #development #computers

Do I need to REINDEX and VACUUM a table after deleting lots of rows?

I am running a PostgreSQL database that has several tables which store logging information. This information is for reporting purposes only and gets dumped to a file and deleted from the database if older than 30 days.

There can be millions of rows deleted, and we have been running a REINDEX each time after deletion.

Is this…

View On WordPress

[sevennet-blog]

Solution: postgreSQL vs Cassandra vs MongoDB vs Voldemort? #programming #solution #dev

Solution: postgreSQL vs Cassandra vs MongoDB vs Voldemort? #programming #solution #dev

postgreSQL vs Cassandra vs MongoDB vs Voldemort? Which database to decide upon? Any comparisions?

Existing: postgresql

Issues

Not easily scalable horizontal. Needs sharding etc

Clustering does not solve the data growth problem

Looking for: Any database that is easily horizontally scalable

Cassandra (Twitter uses that?)

MongoDB (rapidly gaining popularity)

Voldemort

Other?

Why?

Data growing with…

View On WordPress

[starpunchtv]

Microsoft's latest target release date for Office 16: Second half 2015

Microsoft's latest target release date for Office 16: Second half 2015

Microsoft is targeting the second half of calendar 2015 as its latest release target for both its next-generation Office client and server applications.

Original source:

Microsoft's latest target release date for Office 16: Second half 2015

Want more news and entertainment, follow us on Facebook and Twitter and leave us a comment below.

View On WordPress