mcroydon + postgresql 74
10 Ways to Kill Performance.
september 2011 by mcroydon
Postgres performance talk.
database
pdf
performance
postgresql
september 2011 by mcroydon
Postgres Open 2011
september 2011 by mcroydon
A community driven Postgres conference.
postgres
postgresql
conference
september 2011 by mcroydon
PgFoundry: pgbouncer-1.4.2
september 2011 by mcroydon
What to use instead of pgpool.
postgresql
postgres
september 2011 by mcroydon
pqc - PostgreSQL Query Cache - Google Project Hosting
april 2011 by mcroydon
Make postgres go faster.
caching
postgresql
query
april 2011 by mcroydon
Django and Postgresql Performance at WooMe | I Am Seb
november 2010 by mcroydon
"At WooMe, we’ve been using Django and Postgresql in anger for coming up on three years, scaling up to tens of thousands of queries per second means we’ve had to look long and hard at Django’s database support to meet our needs."
performance
django
postgresql
python
november 2010 by mcroydon
Bruce Momjian: Postgres Technical Presentations
november 2010 by mcroydon
Lots and lots of good bits about Postgres.
database
education
learning
howto
postgresql
presentation
tutorial
talk
reference
presentations
november 2010 by mcroydon
5 Minutes to Binary Replication
october 2010 by mcroydon
Postgres 9 the quick way.
database
databases
documentation
howto
infrastructure
sysadmin
replication
reference
postgresql
postgres
october 2010 by mcroydon
Cinderella - A Development Environment for Macs
september 2010 by mcroydon
Interesting take on a multilanguage development environment.
homebrew
administration
chef
configuration
development
environment
node
mongodb
mysql
mongo
memcached
mac
node.js
open
opensource
osx
os
postgresql
programming
x
source
tools
sinatra
rubyonrails
ruby
rvm
september 2010 by mcroydon
What's new in PostgreSQL 9.0 - PostgreSQL Wiki
june 2010 by mcroydon
A really deep feature drilldown.
database
news
postgresql
programming
reference
june 2010 by mcroydon
PostgreSQL: News: PostgreSQL 9.0 Beta 2 Now Available
june 2010 by mcroydon
"Betas are not stable and should never be used in production; they are for testing only. Additional beta releases, or a release candidate, will be available for testing in a few weeks."
postgresql
june 2010 by mcroydon
Another PostgreSQL Diff Tool - Welcome to Another PostgreSQL Diff Tool
june 2010 by mcroydon
Useful for diffing database schemas.
admin
configuration_management
database
databases
db
java
free
evolution
differences
diff
development
dba
management
oss
migration
postgres
postgresql
tools
tool
sql
schema
programming
dbms.postgresql
june 2010 by mcroydon
select * from depesz;» Blog Archive » Waiting for 8.5 – Hot Standby
january 2010 by mcroydon
Already looking forward to 8.5.
databases
scaling
postgresql
read
january 2010 by mcroydon
git.postgresql.org Git - postgresql.git/commit
december 2009 by mcroydon
Looking forward to 8.5 for sure.
postgres
postgresql
database
december 2009 by mcroydon
Graphs in the database: SQL meets social networks – techPortal
october 2009 by mcroydon
Modeling graphs in SQL.
programming
code
database
toread
webdev
howto
tutorial
blog
network
algorithms
performance
article
social
databases
postgresql
graph
mysql
linkedin
datastructures
socialnetworking
webdevelopment
networks
facebook
sql
db
php
graphs
socialnetworks
october 2009 by mcroydon
PostgreSQL Tips and Tricks
august 2009 by mcroydon
#7 is probably the least obvious and sometimes the biggest help in Django apps and #9 probably the most useful in diagnosing problems. All in all it's a fantastic set of things to remember.
postgresql
databases
list
tips
postgres
august 2009 by mcroydon
HadoopDB Project
july 2009 by mcroydon
Interesting approach, we'll see if it has legs.
programming
software
development
database
java
opensource
research
scalability
distributed
performance
scaling
hadoop
cluster
postgresql
databases
mysql
hadoopdb
map-reduce
hive
dbms
rdbms
2009
analytics
postgres
db
sql
mapreduce
yale
vldb
july 2009 by mcroydon
DBMS Musings: Announcing release of HadoopDB (longer version)
july 2009 by mcroydon
/me increments the "databases atop hadoop" counter (and takes a sip).
database
opensource
scalability
research
distributed
performance
hadoop
cluster
postgresql
mapreduce
project
datawarehouse
hadoopdb
distributedcomputing
july 2009 by mcroydon
What happened to Hot Standby?
june 2009 by mcroydon
On hot standby and the future of replication for PostgreSQL.
database
opensource
postgresql
postgres
db
oss
replication
dbms
tumble
dba
june 2009 by mcroydon
Sequoia
may 2009 by mcroydon
"Sequoia is a transparent middleware solution offering clustering, load balancing and failover services for any database."
database
java
performance
cluster
postgresql
mysql
clustering
sql
tool
db
replication
ha
jdbc
highavailability
may 2009 by mcroydon
Greenplum: the petabyte-scale database for data warehousing and business intelligence.
may 2009 by mcroydon
Petabyte data mining and data warehousing.
programming
software
development
data
database
business
technology
opensource
storage
scalability
performance
cluster
postgresql
startup
open
postgres
sql
mapreduce
datamining
db
analytics
oss
reporting
rdbms
intelligence
bi
businessintelligence
datawarehouse
greenplum
bizgres
may 2009 by mcroydon
Paul Ramsey: OpenStreetMap moves to PostgreSQL
april 2009 by mcroydon
The OSM folks come around to Postgres.
maps
free
opensource
postgresql
mysql
postgres
comparison
osm
april 2009 by mcroydon
PostgreSQL: Documentation: Manuals: PostgreSQL 8.3: The Statistics Collector
april 2009 by mcroydon
For when pg_stat_activity isn't helpful enough.
stats
postgresql
database
troubleshooting
april 2009 by mcroydon
Devoh
february 2009 by mcroydon
This sounds sane enough. I modified what flags I gave configure and created a ~/bin/start_postgres and ~/bin/stop_postgres, but this is handy. I didn't want to install from a package this time around.
osx
postgresql
leopard
postgres
macosx
install
february 2009 by mcroydon
Sphinx Search with PostgreSQL at Matt Croydon::Postneo
february 2009 by mcroydon
The one where I get off my butt and actually post something.
sphinx
search
index
indexing
mysql
postgresql
database
information-retrieval
february 2009 by mcroydon
Changeset 9756 - Django - Trac
january 2009 by mcroydon
Yay for test suite running in a sane timeframe!
django
test
testing
postgresql
january 2009 by mcroydon
PostgreSQL Replication, PostgreSQL Support, PostgreSQL Consulting
october 2008 by mcroydon
Mammoth Replicator is now available under an open source license.
design
development
database
sysadmin
scalability
cluster
postgresql
distributed
performance
clustering
chart
databases
postgres
backup
sql
irc
high-availability
db
commercial
replication
distributed-computing
october 2008 by mcroydon
PostgreSQL/Materialized Views - Jonathan Gardner's Tech Wiki
october 2008 by mcroydon
Probably more than I'll ever know about materialized views.
programming
code
howto
database
tutorial
books
wiki
postgresql
databases
postgres
article
sql
dbms
views
materialized
materializedviews
view
october 2008 by mcroydon
bpgsql
september 2008 by mcroydon
Pure-Python PostgreSQL client with experimental Django 1.0 backend.
python
django
database
postgresql
postgres
driver
september 2008 by mcroydon
Persistent Django on Amazon EC2 and EBS - The easy way
august 2008 by mcroydon
Yeah, it's that simple.
python
programming
web
django
development
code
howto
business
webdev
tutorial
amazon
sysadmin
work
web2.0
aws
geek
postgresql
hosting
computers
ec2
postgres
cloud
cloudcomputing
admin
ebs
webservices
persistence
august 2008 by mcroydon
Tuning Your PostgreSQL Server - PostgreSQL Wiki
august 2008 by mcroydon
Malcolm and Jacob have been prodding at Postgres again and have come up with choice links.
database
server
sysadmin
postgresql
performance
postgres
tuning
administration
dba
august 2008 by mcroydon
File Locations
august 2008 by mcroydon
Ooh, annotated configs for 8.3.
database
server
postgresql
configuration
august 2008 by mcroydon
Chapter 6. PostGIS Reference
june 2008 by mcroydon
AsKML(geom) in PostGIS: "Return the geometry as a KML element.." AsSVG rocks too.
geo
gis
manual
postgis
postgresql
reference
june 2008 by mcroydon
cfis : Rails and Postgresql - Eliminate Hundreds of Thousands of Queries a Day
february 2008 by mcroydon
"It turns out that Rails does cache column data dictionary queries (which is what you would expect), but not for :has_and_belongs_to_many associations (HABTMA)."
habtma
rails
postgresql
february 2008 by mcroydon
pgFouine - a PostgreSQL log analyzer
february 2008 by mcroydon
This looks insanely useful. Hadn't seen it before.
analysis
analytics
apache
benchmark
database
databases
debian
development
monitor
optimization
performance
postgres
quality
postgresql
scalability
server
software
sysadmin
sql
system
tools
february 2008 by mcroydon
WorkshopFOSS4G2007 - pgRouting - Trac
november 2007 by mcroydon
PGRouting + OpenLayers demo.
gis
postgis
postgresql
november 2007 by mcroydon
pgRouting - Trac
november 2007 by mcroydon
Via geowanking.
algorithm
free
gis
postgis
postgres
postgresql
research
routing
november 2007 by mcroydon
PostgreSQL: Documentation: Manuals: PostgreSQL 8.2: COPY
october 2007 by mcroydon
"copy (select * from tablename) to stdout with csv;" Fantastic.
csv
postgresql
october 2007 by mcroydon
PostgreSQL warm standby on ZFS crack - Esoteric Curio
july 2007 by mcroydon
Insanely wicked, via Jacob.
database
filesystem
postgres
postgresql
recovery
replication
solaris
zfs
ftw
july 2007 by mcroydon
PgFoundry: PostgreSQL Loader: Project Info
may 2007 by mcroydon
Joseph pointed this out the other day and I'm going to try my hardest not to forget about it the next time I could use it...
postgres
python
postgresql
may 2007 by mcroydon
SkypeGarage/DbProjects/SkyTools/WalMgr - Skype Developer Zone
may 2007 by mcroydon
Simpler than it looks
postgres
database
pyhon
postgresql
may 2007 by mcroydon
EXPLAIN plan Operators
may 2007 by mcroydon
Thanks for pointing this out, Jacob!
postgresql
postgres
reference
database
may 2007 by mcroydon
PostGIS Wiki : Examples Join Tables
february 2007 by mcroydon
Relating geo and non-geo data in Postgresql.
sql
geo
geowanking
geolocation
postgres
postgresql
postgis
february 2007 by mcroydon
[postgis-users] Center of a path.
february 2007 by mcroydon
Finding the center of a path with PostGIS
postgis
postgres
postgresql
maps
mapping
geowanking
geolocation
february 2007 by mcroydon
Page2RSS: PostgreSQL vs. MySQL Performance
january 2007 by mcroydon
"That sharp drop in the middle of December is when we switched to the PostgreSQL."
databases
development
mysql
postgres
postgresql
programming
january 2007 by mcroydon
Mapping Hacks » Blog Archive » trackgpx2shp.pl and the Mapping Hacks code page
january 2007 by mcroydon
This is definitely a start.
geo
maps
perl
geowanking
geolocation
postgresql
postgis
january 2007 by mcroydon
The Pochi Superstar Mega Show! » Projects
january 2007 by mcroydon
Working with geo datatypes (PostGIS, etc) in Ruby.
gis
mapping
maps
mysql
postgresql
postgis
rails
ruby
january 2007 by mcroydon
PostgreSQL store (Re: status update)
january 2007 by mcroydon
First shot at a postgres backend for mogilefs.
mogilefs
danga
sixapart
open-source
perl
postgres
postgresql
january 2007 by mcroydon
Installing PostGIS on Ubuntu Dapper Server (6.06) - UMassLUGWiki
january 2007 by mcroydon
Ah, 1.2.0 isn't happy for me but 1.1.6 works just fine.
database
linux
postgres
postgresql
server
ubuntu
january 2007 by mcroydon
PostGIS Wiki : Postgis On Ubuntu
january 2007 by mcroydon
For later: figure out why this didn't work for my on Dapper.
geo
postgresql
ubuntu
january 2007 by mcroydon
Enfranchised Mind » Postgres for the win!
december 2006 by mcroydon
Reason 3,287,337 why Postgres rules.
database
databases
development
partition
postgres
postgresql
sql
tables
december 2006 by mcroydon
PostgreSQL for MySQL users | Linux Box Admin
december 2006 by mcroydon
Postgres for MySQL heads.
database
mysql
postgresql
server
sql
december 2006 by mcroydon
Esoteric Curio
november 2006 by mcroydon
One smart cookie.
architecture
blog
blogs
os
postgres
postgresql
november 2006 by mcroydon
Welcome to phpPgAds / Open-source ad server / phpAdsNew PostgreSQL port
november 2006 by mcroydon
Another online ad management suite to keep an eye on. It looks pretty spankin' new but I love the postgres support.
ad
free
php
postgresql
software
webdesign
web
november 2006 by mcroydon
SkypeGarage/DbProjects/SkyTools - Skype Developer Zone
november 2006 by mcroydon
Jacob stumbled upon this earlier. I think it has a ton of potential.
skype
postgres
postgresql
database
replication
november 2006 by mcroydon
whenpenguinsattack.com: mysql vs postgres
february 2006 by mcroydon
The lone "No" in the Postgres list (and this is 7,x, not the current 8.x) can be replaced with "Yes" if you use PostGIS.
database
mysql
postgresql
postgres
february 2006 by mcroydon
Annotated PostgreSQL 8.0 configuration file
november 2005 by mcroydon
Save for a rainy day.
postgresql
annotated
database
reference
november 2005 by mcroydon
PostGIS
november 2005 by mcroydon
A new release is out the door.
postgresql
gis
geolocation
geowanking
november 2005 by mcroydon
pgpool page
october 2005 by mcroydon
Connection pooling for Postgres
database
linux
postgresql
sysadmin
october 2005 by mcroydon
Slony-I Administration
october 2005 by mcroydon
Great resource on PostgreSQL replication
postgresql
slony
slonyd
october 2005 by mcroydon
freshmeat.net: Project details for psycopg
october 2005 by mcroydon
Version 1.1.21 is out the door.
python
postgresql
database
db-api
october 2005 by mcroydon
related tags
acm ⊕ ad ⊕ admin ⊕ administration ⊕ algorithm ⊕ algorithms ⊕ amazon ⊕ analysis ⊕ analytics ⊕ annotated ⊕ apache ⊕ apple ⊕ architecture ⊕ article ⊕ aws ⊕ backup ⊕ benchmark ⊕ benchmarks ⊕ bi ⊕ big ⊕ bizgres ⊕ blog ⊕ blogs ⊕ books ⊕ business ⊕ businessintelligence ⊕ caching ⊕ chart ⊕ chef ⊕ cloud ⊕ cloudcomputing ⊕ cluster ⊕ clustering ⊕ code ⊕ commercial ⊕ comparison ⊕ compsci ⊕ computer ⊕ computers ⊕ conference ⊕ configuration ⊕ configuration_management ⊕ csv ⊕ danga ⊕ data ⊕ database ⊕ databases ⊕ datamining ⊕ datastructures ⊕ datawarehouse ⊕ db ⊕ db-api ⊕ dba ⊕ dbms ⊕ dbms.postgresql ⊕ dbs ⊕ debian ⊕ deployment ⊕ design ⊕ development ⊕ diff ⊕ differences ⊕ distributed ⊕ distributed-computing ⊕ distributedcomputing ⊕ django ⊕ documentation ⊕ driver ⊕ ebs ⊕ ec2 ⊕ education ⊕ email ⊕ engineering ⊕ environment ⊕ evolution ⊕ facebook ⊕ filesystem ⊕ free ⊕ ftw ⊕ geek ⊕ geo ⊕ geolocation ⊕ geowanking ⊕ gis ⊕ graph ⊕ graphs ⊕ greenplum ⊕ ha ⊕ habtma ⊕ hadoop ⊕ hadoopdb ⊕ high-availability ⊕ highavailability ⊕ hive ⊕ homebrew ⊕ hosting ⊕ howto ⊕ imap ⊕ index ⊕ indexing ⊕ information-retrieval ⊕ infrastructure ⊕ instagram ⊕ install ⊕ intelligence ⊕ internet ⊕ irc ⊕ java ⊕ jdbc ⊕ la ⊕ learning ⊕ leopard ⊕ library ⊕ linkedin ⊕ linux ⊕ list ⊕ mac ⊕ macintosh ⊕ macosx ⊕ mail ⊕ management ⊕ manual ⊕ map ⊕ map-reduce ⊕ mapping ⊕ mapreduce ⊕ maps ⊕ materialized ⊕ materializedviews ⊕ memcached ⊕ migration ⊕ mogilefs ⊕ mongo ⊕ mongodb ⊕ monitor ⊕ mysql ⊕ network ⊕ networks ⊕ news ⊕ node ⊕ node.js ⊕ open ⊕ open-source ⊕ opensource ⊕ optimization ⊕ os ⊕ osm ⊕ oss ⊕ osx ⊕ partition ⊕ pdf ⊕ performance ⊕ perl ⊕ persistence ⊕ pgsql ⊕ php ⊕ pop ⊕ postfix ⊕ postgis ⊕ postgres ⊕ postgresql ⊖ presentation ⊕ presentations ⊕ programming ⊕ project ⊕ pyhon ⊕ python ⊕ quality ⊕ query ⊕ rails ⊕ rdbms ⊕ read ⊕ recovery ⊕ reference ⊕ replication ⊕ reporting ⊕ research ⊕ routing ⊕ ruby ⊕ rubyonrails ⊕ rvm ⊕ scalability ⊕ scale ⊕ scaling ⊕ schema ⊕ search ⊕ server ⊕ servers ⊕ sinatra ⊕ sixapart ⊕ skype ⊕ slony ⊕ slonyd ⊕ smtp ⊕ social ⊕ socialnetworking ⊕ socialnetworks ⊕ software ⊕ solaris ⊕ source ⊕ sphinx ⊕ sql ⊕ startup ⊕ stats ⊕ storage ⊕ sysadmin ⊕ system ⊕ tables ⊕ talk ⊕ technology ⊕ test ⊕ testing ⊕ tips ⊕ tool ⊕ tools ⊕ toread ⊕ troubleshooting ⊕ tumble ⊕ tuning ⊕ tutorial ⊕ ubuntu ⊕ utilities ⊕ view ⊕ views ⊕ vldb ⊕ web ⊕ web2.0 ⊕ webdesign ⊕ webdev ⊕ webdevelopment ⊕ webservices ⊕ wiki ⊕ work ⊕ x ⊕ xpath ⊕ yale ⊕ zfs ⊕Copy this bookmark: