| From: | Sean Chittenden <sean(at)chittenden(dot)org> |
|---|---|
| To: | josh(at)agliodbs(dot)com |
| Cc: | SF Postgres <sfpug(at)postgresql(dot)org> |
| Subject: | Re: Hey! RSVP for Monday? |
| Date: | 2004-11-12 20:26:21 |
| Message-ID: | 1DF3C426-34E9-11D9-BAD3-000A95C705DC@chittenden.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | sfpug |
> We really DO need to know how many people to expect for Monday. How
> about a
> quick e-mail?
:) I'll be there and arriving via bart. What time is the bus/van/car
leaving from bart?
In case anyone's wondering what memcache can do for a site, I just
finished adding memcache to a particularly hot spot on the site that
was killing PostgreSQL. The page in question was doing a SELECT
COUNT(*) + SELECT * (I didn't write it, I wouldn't have used SELECT *)
which was resulting in about 320K of data per page view being sent
across the wire Pg to the webserver. Yesterday, the load reached 75-80
as queries piled up. Here's a graph of the load from a day ago and the
load from today.
| Attachment | Content-Type | Size |
|---|---|---|
| pastedGraphic1.tiff | image/tiff | 10.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-11-12 21:05:51 | Re: Hey! RSVP for Monday? |
| Previous Message | Josh Berkus | 2004-11-12 17:58:03 | Hey! RSVP for Monday? |