[fdo-users] postgis and performance

[Traian Stanev]

Yes, to get best performance for this many features, consider publishing a snapshot of the data, exported to SDF or SHP format for example.

Traian


> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-
> bounces at lists.osgeo.org] On Behalf Of alucas
> Sent: Monday, July 28, 2008 3:08 AM
> To: fdo-users at lists.osgeo.org
> Subject: Re: [fdo-users] postgis and performance
>
>
> Hi zac,
>
> But... Views are more slowly than tables. The best choice would be to
> change
> the provider to avoid this string matching.
>
> Regards.
>
>
> zspitzer wrote:
> >
> > For better performance, try using views on your tables which only
> > expose the minimal
> > set of columns you require.
> >
> > Mapguide does "select * from table" which slows things down a lot,
> > because each column
> > is accessed via name rather than index and that's a lot of string
> > matching..
> >
> > http://trac.osgeo.org/mapguide/ticket/272
> >
> > i.e. with a 500k row table, each additional column is now involved in
> > another 500k of string matches
> >
> > Regards
> >
> > Zac
> >
> > On Sat, Jul 26, 2008 at 1:09 AM, alucas <alucas at srtec.com> wrote:
> >>
> >> Hello List,
> >>
> >> I'm testing postgis to store some Gregraphic layers and publish this
> data
> >> to
> >> the internet via Mapguide Enterprise 2009. I've performance problems
> to
> >> publish some large volumes of vector data. For example, mapguide
> can't
> >> preview (with Autodesk Mapguide Studio) one layer with 140.000
> records. I
> >> need to publish some layers with aprox 500.000 records
> >>
> >> So, I need to manage large volume data sets with postgis and
> mapguide and
> >> I've some questions:
> >>
> >> - In the unit tests for the postgis provider, what are the volumes
> of
> >> data
> >> tested?
> >> - I've loaded the data into postgis via shp2pgsql. I don't know if
> the
> >> default database created via shp2pgsql is the best for the postgis
> >> provider
> >> performance. It's possible to improve the database performance for
> >> example
> >> creating some gist indexes? If yes, how can I create the optimal
> index to
> >> achieve the best performance in queries?
> >>
> >> To summarize, I need some help for optimize my postgis datastore...
> >>
> >> Some useful information about the system:
> >>
> >> MGE 2009
> >> Autodesk Mapguide Studio 2009
> >> Postgis 8.2.9
> >> Postgis 1.3.3
> >> FDO provider for postgis: 3.3.0 (Downloaded from GeoMap web page)
> >>
> >> Thanks in advance.
> >>
> >>
> >> --
> >> View this message in context:
> >> http://www.nabble.com/postgis-and-performance-
> tp18653591p18653591.html
> >> Sent from the FDO Users mailing list archive at Nabble.com.
> >>
> >> _______________________________________________
> >> fdo-users mailing list
> >> fdo-users at lists.osgeo.org
> >> http://lists.osgeo.org/mailman/listinfo/fdo-users
> >>
> >
> >
> >
> > --
> > Zac Spitzer -
> > http://zacster.blogspot.com (My Blog)
> > +61 405 847 168
> > _______________________________________________
> > fdo-users mailing list
> > fdo-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/fdo-users
> >
> >
>
> --
> View this message in context: http://www.nabble.com/postgis-and-
> performance-tp18653591p18685149.html
> Sent from the FDO Users mailing list archive at Nabble.com.
>
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users