Just wondering what I can do to squeeze out more performance of my database
application? Here's my configuration:
- Mac mini server
- Core i7 quad-core at 2GHz
- 16GB memory
- Dedicated fast SSD (two SSDs in the server)
- Mac OS X 10.7.2 (*not* using OS X Server)
- PostgreSQL 9.05
- PostGIS 1.5.3
OK, great. Thank. And when I recreate it, should I do so from a template, or
just CREATE DATABASE postgres ?
On 2011-10-26, at 4:10 PM, Tom Lane wrote:
> =?iso-8859-1?Q?Ren=E9_Fournier?= writes:
>> I accidentally imported lots of data into the postgres database via
>> something like:
>> psql -
I accidentally imported lots of data into the postgres database via something
like:
psql -U postgres -q -f super_massive_database_dump.sql
Now, although I've manually dropped all the tables -- and \d+ shows nothing --
there are still various views, functions, etc that must account for a lot of
[…]
---> Installing postgresql90-server @9.0.5_0
To create a database instance, after install do
sudo mkdir -p /opt/local/var/db/postgresql90/defaultdb
sudo chown postgres:postgres /opt/local/var/db/postgresql90/defaultdb
sudo su postgres -c '/op
:31 PM, Andy Colson wrote:
> On 10/12/2011 06:38 PM, Andy Colson wrote:
>> On 10/12/2011 06:29 PM, Andy Colson wrote:
>>> On 10/12/2011 01:01 PM, René Fournier wrote:
>>>> Hi,
>>>>
>>>> I'm developing a reverse-geocoder for Canada. So
Hi,
I'm developing a reverse-geocoder for Canada. So far, given a lat/lng, I can
find the nearest street (line segment), which includes line segment direction
and address ranges for both sides of the street. I'm now trying to figure out
the best way to programmatically approximate the nearest h
865CC033F3484066865CC0CD8C49409A795CC0CDCCCC8C49409A795CC033F3484066865CC033F34840'::geometry)
(7 rows)
Does this appear optimal to you?
Best regards,
René Fournier
Wow, have to say, I love Postgresql and PostGIS. Just awesome.
So I have a table with ~400,000 rows, each representing a road or street (multi
line segment). I want to select the row whose line segment is closest the a
given point. The following query...
gc3=# SELECT r_stname_c, r_placenam,
ST
On 2011-10-07, at 7:58 PM, Scott Ribe wrote:
> On Oct 7, 2011, at 7:39 PM, René Fournier wrote:
>
>> Plus, I find Macports makes it easy to automate a server build in one
>> script. The problem as I see it isn't Macports but my unfamiliarity with
>> Postgresql.
with Postgresql.
On 2011-10-07, at 6:21 PM, Scott Ribe wrote:
> On Oct 7, 2011, at 5:38 PM, René Fournier wrote:
>
>> (Sorry, I'm a MySQL guy. I'm just trying to get started without asking too
>> many dumb questions.)
>
> Frankly, I think you'd be b
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
ERROR: current transaction is aborted, commands ignored until end of
transaction block
Appears as though Postgis isn't even 'there'.
(Sorry, I'm a MySQL guy. I'm just trying to get started without asking too many
dumb questions.)
Best regards,
René Fournier
Hi Scott,
On 2011-10-07, at 2:57 PM, Scott Ribe wrote:
> On Oct 7, 2011, at 2:24 PM, René Fournier wrote:
>
>> I've tried installation 8.4 and 9.0 on two different machines, and at the
>> end can't start Postgresql. Here's the basic story:
>
> You can
I've tried installation 8.4 and 9.0 on two different machines, and at the end
can't start Postgresql. Here's the basic story:
[…]
---> Building postgresql90-server
---> Staging postgresql90-server into destroot
---> Creating launchd control script
##
13 matches
Mail list logo